paste special problem
paste special problem
- Subject: paste special problem
- From: email@hidden
- Date: Fri, 22 Mar 2002 11:02:15 EST
greetings. i am having trouble properly constructing a paste special command.
i have written a script that copies a screen report from myob into excel,
then copies the data from one excel spreadsheet to another. since the
original myob report is in a highly stylized format which i don't want to
use, when i paste the info into the 2nd excel spreadsheet, i use the paste
special command so only the values are pasted.
in visual basic, the macro command looks like this:
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
i can't figure out how the variables are supposed to be separated in
applescript: by brackets, by commas, by lines. . . .
i notice in applescript that paste special wants to be told a specific
destination. since i want the paste to begin at the cell which is active
when i invoke the script, i added a string which creates a new name in the
active cell called "new." i don't know if this is necessary.
your help in properly constructing the paste special command into applescript
would be most appreciated.
anna saint john
email@hidden
_______________________________________________
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.