Apple

property theFilepath : "/Users/yourusername/Desktop/filename.txt"

set theFile to POSIX file theFilepath as text

tell application "Microsoft Excel"
save workbook as workbook 1 filename theFile file format text Mac file format
end tell

But i have no solution for "with replacing".

It looks like that there is no option for this in the dictionary.

Am 08.05.2009 um 21:00 schrieb email@hidden:

Von: Oakley Masten <email@hidden>
Datum: 7. Mai 2009 21:44:35 MESZ
An: Users Group AppleScript <email@hidden>
Betreff: Excel Save as text question

This saves the file with the name and path just fine but it is not really a text(tab delimited) file.
It is still some kind of Excel file.
What am I doing wrong here?

set TargetFolder to "Macintosh HD:Users:omasten:Desktop:ExcelTest"
set theSaveName to (TargetFolder as text) & ":" & "FirstFile.txt"
tell application "Microsoft Excel"
activate

set OriginalSaveFormat to default save format
--Change the defalut save format
set default save format to text Mac
--set default save format to workbook normal file format

tell active sheet
save as filename theSaveName with replacing
end tell

set default save format to OriginalSaveFormat
end tell

I want to create a new file.
Then populate it with data.
They save it as a txt file.
Also the "with Replacing" doesn't appear to work all the time.

Any help would be appreciated

Thanks
Oakley

Von: Oakley Masten <email@hidden>
Datum: 7. Mai 2009 21:53:41 MESZ
An: Users Group AppleScript <email@hidden>
Betreff: re:Excel Save as text question

Sorry - I forgot to add.

Using Excel 2004 on OSX 10.4.11

Thanks
Oakley