Re: Scripting Excel
Re: Scripting Excel
- Subject: Re: Scripting Excel
- From: Brian <email@hidden>
- Date: Sat, 19 Feb 2005 16:22:56 +0100
Le 19 févr. 05, à 13:11, Gonçalo Miguel a écrit :
Hello i’m a beginner in script, does some one noes how to script inside excel. Like create new lines whitout replace the one befor?
tanks
Gonçalo
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
Hello, excel can be 'recorded', so you can use the 'Record' button of the Script Editor and then go do something in excel to see what command you can use in your script. Or just open the excel dictionary, in the Script Editor to.
For inserting lines :
tell application "Microsoft Excel"
Activate
Select Range "L5C1" -- Mean Line/Row 5 - Column 1 = cell A5
repeat 5 times
Insert EntireRow of Selection
end repeat
-- Will insert 5 lines before cell A5
end tell
Brian _______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
| References: | |
| | >(no subject) (From: Gonçalo Miguel <email@hidden>) |