I have looked through many of the posts for excell 2004 on here and have not found my answer so I am posting this question.
I have a script that opens an excel file to get values out of it. However, I am getting an error saying that:
Microsoft Excel got an error: alias “Console 2 :Users:console2:Desktop:nevember 19:operating.xls” doesn’t understand the open message.
I only get this when Microsoft excel is first activating. does it have something to do with the project gallery coming up??? If I say cancel to the project gallery, leave excel open, and run the script again it opens up the file fine.
my code to access the file and my process is as follows:
I get the filesList from the finder
repeat with aFile in filesList
set fileIndex to 0
set theFile to aFile as alias
then I tell Microsoft Excell to open theFile
This process has worked for me with Photoshop 7 and sense it opens fine on the second attempt it is hard to believe it is the code. I rather believe I am not telling Excell something that I should be.
Thank you for your help,
Teddy