Thanks. The following works:, , method pushButton(var eventInfo Event), var, q1 query, tc1 tcursor, qAssigned string, spreadSheetName string, endVar, , tc1.open("log.DB"), Scan tc1:, , qAssigned= "\"" + tc1."assigned to" + "\"", spreadSheetName = "WorkLoad_" + tc1."assigned to" + ".xls", , Q1 = Query, ANSWER: :PRIV:ANSWER.DB, :LOG:log.db | Date Received | Year | Number |, | Check as recd | Check | Check as Lognum |, :LOG:log.db | Branch | Assigned To |, | Check | ~qAssigned |, :LOG:log.db | Project Name | Date Completed |, | Check | blank |, EndQuery, , If not(executeQBE(Q1)) then, errorShow(), msginfo("Error","Unable to run query"), endIf, , exportSpreadsheet ( ":PRIV:ANSWER.db", spreadSheetName, True ), , endScan, endMethod

Posted to MB Topic: ObjectPAL « Paradox Board

{Too Long!}

Posted to MB Topic: ObjectPAL « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox Forms « Paradox Board