Mixing Apple Script, Excel and a network
Mixing Apple Script, Excel and a network
- Subject: Mixing Apple Script, Excel and a network
- From: Courtney Moore <email@hidden>
- Date: Fri, 15 Aug 2003 17:06:42 -0500
Thanks everyone for your help so far! I've almost got it! I fixed the copy
and paste problem by creating a new layout with only the field that I want
to copy. Not the most satisfying fix but it works.
With regards to the importing side of things I have run into an interesting
problem. When using the syntax, mentioned below, to open a file in
Microsoft Excel I have no problems when using my machine that is not
authenticating. When I try the syntax on my networked machine I get the
following error:
"Microsoft Excel got an error: "pathToFile" doesn't understand the OpenText
message."
Not quite sure what the deal it, does anyone have any ideas?!!
Syntax:
Tell application "Microsoft Excel"
Activate
OpenText "pathToFile" Orgin xlMacintosh StartAtRow 1
DataType xlDelimited TextQualifier xlDoubleQuote FieldInfo {{7.0, 1.0},
{2.0, 1.0}, {3.0, 1.0}, {4.0, 1.0}, {5.0, 1.0}, {6.0, 1.0}, {7.0, 1.0}} with
CommaDelimiter without Treat ConsecutiveDelimitersAsOne, TabDelimiter,
SemicolonDelimiter, SpaceDelimiter and Other
End tell
You guys are great! Can't wait till I am experienced enough to be on the
other side!
Courtney
_______________________________________________
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.