Re: Importing to Excel
Re: Importing to Excel
- Subject: Re: Importing to Excel
- From: Paul Berkowitz <email@hidden>
- Date: Thu, 14 Aug 2003 13:15:56 -0700
On 8/14/03 12:59 PM, "Courtney Moore" <email@hidden> wrote:
>
Here is the syntax that I used:
>
>
set TextFileToImport to "Users:courtney:Desktop:AStest.txt" as string
>
tell application "Microsoft Excel"
>
Open text TextFileToImport with CommmaDelimiter
>
set NumberFormat of Range ("B:B") to "#.000000"
>
end tell
1) You've got an extra "m" in "CommmaDelimiter".
2) You've omitted the name of your startup disk --"Macintosh HD" or whatever
you've named it to (check the disk icon in top rihght corner of your desktop
to verify):
set TextFileToImport to "Macintosh HD:Users:courtney:Desktop:AStest.txt"
(It already is a string, doesn't need a coercion.)
3) The Excel command "OpenText" is one word with no space. You inserted a
space.
--
Paul Berkowitz
_______________________________________________
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.