Re: As and Excel
Re: As and Excel
- Subject: Re: As and Excel
- From: Stan Cleveland <email@hidden>
- Date: Thu, 02 May 2013 14:15:57 -0700
On May 2, 2013, at 1:19 PM, Robert Cuilla wrote:
> I need to open an Excel spreadsheet, "sheet1xlsx, and then delete column 3. Any help is appreciated
Hi Bob,
How about this?:
tell application "Microsoft Excel"
open alias "MacHD:Users:stanc:Desktop:Excel_doc.xlsx"
delete range range "C:C"
end tell
What seems like terminology stutter ("range range" in line 3) is more understandable if we split that line into the command (delete range) and its object (range "C:C").
I'm using Excel 2011, but the code above should work for Excel 2004 or later. Excel has a scripting dictionary that is broad, deep, and rich.
Enjoy,
Stan C.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden
| References: | |
| | >As and Excel (From: Robert Cuilla <email@hidden>) |