Re: Extract Text From Spreasheets
Re: Extract Text From Spreasheets
- Subject: Re: Extract Text From Spreasheets
- From: Tom Bilski <email@hidden>
- Date: Tue, 13 Jul 2004 14:31:19 -0400
Here is another way so that you don9t have to use a text app...
tell application "Microsoft Excel"
set exportFile to Value of Range "exportfile" --- name the range in
Excel for ease of use
end tell
set saveDelims to AppleScript's text item delimiters
set AppleScript's text item delimiters to {return}
set exportFile to exportFile as list
set file_ref to open for access file "Macintosh HD:myFile.txt" with write
permission
set eof file_ref to 0
write (((exportFile) as text) & return) to file_ref
close access file_ref
set AppleScript's text item delimiters to saveDelims
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.