Excel Macro (AppleScript) problem.

I have been trying to write an Excel Macro (or AppleScript) to do the
following:

Open Excel sheet.
Open Explorer
Find data.
Copy data.
Quit Explorer
Return to Excel
Paste data.
End

I do this manually and it works beautifully.
Both the recorded Macro (and the AppleScript) seem ok. Then I try them
again and they work. However when I Quit and then try again I get an error
message that says Excel gets hung up at the "paste" command.

What am I doing wrong, and can anyone help solve my problem?

Jack

Hi Jack,

I could be wrong, but if you are looking to import data from tables then
perhaps a web query is the way to go.
<a rel="nofollow" style='text-decoration: none;' href="http://www.agentjim.com/MVP/Excel/ExcelHome.htm" target="_blank">http://www.agentjim.com/MVP/Excel/ExcelHome.htm</a>

A free download so all you have to do is enter the URL of the web page is
here:
<a rel="nofollow" style='text-decoration: none;' href="http://www.versiontracker.com/dyn/moreinfo/macosx/18898" target="_blank">http://www.versiontracker.com/dyn/moreinfo/macosx/18898</a>

If this is not what you are seeking, can you provide information about the
kind of data your are trying to import?

Thanks.

--
Jim Gordon
Mac MVP


On 1/19/04 6:32 PM, in article BC31A914.3545%nigaja@adelphia.net, "Jack
Hachigian" wrote:

 > I have been trying to write an Excel Macro (or AppleScript) to do the
 > following:
 >
 > Open Excel sheet.
 > Open Explorer
 > Find data.
 > Copy data.
 > Quit Explorer
 > Return to Excel
 > Paste data.
 > End
 >
 > I do this manually and it works beautifully.
 > Both the recorded Macro (and the AppleScript) seem ok. Then I try them
 > again and they work. However when I Quit and then try again I get an error
 > message that says Excel gets hung up at the "paste" command.
 >
 > What am I doing wrong, and can anyone help solve my problem?
 >
 > Jack