Re: Need Excel AppleScript for Office 2004 for Macintosh
Re: Need Excel AppleScript for Office 2004 for Macintosh
- Subject: Re: Need Excel AppleScript for Office 2004 for Macintosh
- From: Stan Cleveland <email@hidden>
- Date: Mon, 01 Oct 2007 18:52:51 -0700
- Thread-topic: Need Excel AppleScript for Office 2004 for Macintosh
On 10/1/07 6:35 PM, I wrote:
> I checked the Excel 2004 dictionary and attempted the copy/paste special
> trick. The code I tried is below. It compiles and runs without error, but
> doesn't remove blank cells as expected. It just seems to copy, then paste
> the range unchanged. Perhaps another Excel scripter has an idea on how to
> get it working.
>
> tell application "Microsoft Excel"
> set cut copy mode to copy mode
> activate
> cut range range "A1:AZ300"
> paste special range "A1:AZ300" what paste all with skip blanks
> end tell
Hmmm. It just occurred to me to try paste special in the GUI with the "Skip
blanks" option checked to see if blanks are removed. They're not. Whether
the blank range is a single cell or an entire row or column, it remains.
Unless I'm missing something, it would appear that Deivy's clever idea for
killing white space doesn't work. The code was fast, though. Less than a
second on my Mac.
Stan C.
"We're lost, but we're making good time!" :-)
_______________________________________________
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