Save as Excel 4.0 Workbook

Scripting Forums AppleScript | Mac OS X
#1

This script works great until I want to open the document called WordCounts.xls and save it as an Excel 4.0 Workbook.

What’s missing?

Dave

tell application “Finder”
duplicate “Macintosh HD:WordCounts.xls” to “Macintosh HD:wcreport” with replacing
end tell
tell application “Microsoft Excel”
open “Macintosh HD/wcreport/WordCounts.xls”
save “WordCounts.xls” as Excel4
end tell

Model: PowerBook G4
AppleScript: 2.1.1
Browser: Safari 419.3
Operating System: Mac OS X (10.4)

#2

Nice try. I get an Applescript error saying workbook 1 doesn’t understand the save message.

I tried it as Excel4 and as text and as excel9795.

Uggh!

#3

That did it.

Now can you make the excel4 spreadsheet automatically close?

#4

actually I figured out how to close.
my next step is to do this on a timer, once an hour.