To be more explanatory, part of my script is as follows:
tell application "Finder" -- Script Debugger 4.5 activate set the clipboard to "" activate document file "Test Solver.xls" of folder "Desktop" of folder "lungmummy" of folder "Users" of startup disk select window of desktop activate document file "NHANESIII_Database Graphs&Indices.fp7" of folder "Desktop" of folder "lungmummy" of folder "Users" of startup disk select window of desktop set FNr to 0 set BCnr to 0 set SqNr to 0 tell application "FileMaker Pro" activate --go to field SEQN --- The variable SEQN is not defined. --copy field {SEQN, NHANESIII - Spirometry} --- The variable SEQN is not defined. set value of field SEQN of document file "NHANESIII_Database Graphs&Indices.fp7" to SqNr -- FileMaker Pro got an error: Object not found. end tell -- When SqNr was copied in 2 seconds by a Filemaker script into the clipbord, -- and then pasted by a macro on row 17 of column 17 the next on Excel worked fine: tell application "Microsoft Excel" activate activate object workbook "Test Solver.xls" set (value of row 17 of column 17) to SqNr wait 2 set FNr to (value of row 17 of column 16) -- with an addition of ".csv" by a cell formula. set (value of row 25 of column 11) to SqNr wait 2 end tell -- WHY NOT IN FILEMAKER? Not to speak yet about so many Applescript variables -- with Excel calculation values, which have to be imported into Filemaker fields. -- I could not find help in "Filemaker Pro.app's" dictionary from Script Debugger 4 or 4.5. -- But who am I? end tell
Willem Vriend.
|