Re: Excel Save as text question
Re: Excel Save as text question
- Subject: Re: Excel Save as text question
- From: "Stockly, Ed" <email@hidden>
- Date: Wed, 20 May 2009 14:56:32 -0700
- Thread-topic: Excel Save as text question
Title: Re: Excel Save as text question
>>>Unfortunately, it still does not overwrite.
Hmmm, Run this and tell us what displays in the dialog.
What version are you in again? I’ve got Excel 2008.
ES
set targetFolder to path to desktop
set excelTextFileName to "excelTest"
set myFile to ((targetFolder as text) & excelTextFileName)
tell application "Microsoft Excel"
make new document at beginning
repeat with x from 1 to 12
tell worksheet 1
tell column 1
tell cell 1
set value to x
end tell
end tell
save as filename myFile file format text Mac file format with overwrite
end tell
end repeat
end tell
display dialog (read file myFile)
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden