D
Diane Ross
------ Forwarded Message from Entourage newsgroup -----------
From: <[email protected]>
Newsgroups: microsoft.public.mac.office.entourage
Date: Thu, 6 Mar 2008 15:32:16 -0800
Subject: Save as XML with Applescript and Excel 2008
I used to have a VBA macro that saved my current active workbook as an XML
spreadsheet in Excel 2004 and now I'm trying to get the same function using
Applescript. I can get it to change the file name and save and automatically
overwrite without any problems, however, it doesn't change the file format
to XML. It saves it as the new xlsx format. The "VBA to AppleScript
Migration Guide" doesn't work at all because they use the wrong syntax there
for Excel 2008 and the syntax that the Applescript Dictionary suggests
doesn't work for the "file format" parameter, although it doesn't throw any
error messages. The code below is what I currently have and that one will
save the file, change the file name and overwrite any already existing
files. But it doesn't save it as XML... Has anyone had this problem before
or know what I'm doing wrong?
tell application "Microsoft Excel"
save as active sheet filename "network.xml" file format "Excel XML file
format" with overwrite
end tell
------ End of Forwarded Message
From: <[email protected]>
Newsgroups: microsoft.public.mac.office.entourage
Date: Thu, 6 Mar 2008 15:32:16 -0800
Subject: Save as XML with Applescript and Excel 2008
I used to have a VBA macro that saved my current active workbook as an XML
spreadsheet in Excel 2004 and now I'm trying to get the same function using
Applescript. I can get it to change the file name and save and automatically
overwrite without any problems, however, it doesn't change the file format
to XML. It saves it as the new xlsx format. The "VBA to AppleScript
Migration Guide" doesn't work at all because they use the wrong syntax there
for Excel 2008 and the syntax that the Applescript Dictionary suggests
doesn't work for the "file format" parameter, although it doesn't throw any
error messages. The code below is what I currently have and that one will
save the file, change the file name and overwrite any already existing
files. But it doesn't save it as XML... Has anyone had this problem before
or know what I'm doing wrong?
tell application "Microsoft Excel"
save as active sheet filename "network.xml" file format "Excel XML file
format" with overwrite
end tell
------ End of Forwarded Message