Re: Importing to Excel and Finding a Path
Re: Importing to Excel and Finding a Path
- Subject: Re: Importing to Excel and Finding a Path
- From: Courtney Moore <email@hidden>
- Date: Thu, 14 Aug 2003 16:19:27 -0500
On 8/14/03 3:15 PM, "Paul Berkowitz" <email@hidden> wrote:
>
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.
Wow! Looks like I need to double check my typing! Can you say type-os!
Thanks for the extra eyes!
With regards to the path of the file I am on a network so it is tricky to
find the path. I know that there is an applescript you can use to get a
path of a file but I can't seem to find where I put the article. Are you
familiar with how to script finding a path?
_______________________________________________
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.