problem using Applescript with Excel
problem using Applescript with Excel
- Subject: problem using Applescript with Excel
- From: email@hidden
- Date: Wed, 13 Dec 2000 12:43:34 EST
Hi list folks,
Total newbie question: a portion of my script is meant to copy the data in a
cell in an Excel spreadsheet, then go on & do something else.
set var1 to 1
tell application "Microsoft Excel"
Activate
Select Sheet "Sheet3"
Select Range "R1C13"
set CutCopyMode to false
CopyObject Selection
Activate
set var2 to the clipboard
end tell
--now do something else
if var1 = var2 then
display dialog ("blah")
else
display dialog ("blahblah")
end if
I can't get the script to move on past the "end tell". The application menu
flashes a Script Editor icon at me & when I select Script Editor, then the
script will continue. What am I missing?
Thanks,
Tim Myers