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: deivy petrescu <email@hidden>
- Date: Mon, 1 Oct 2007 23:17:26 -0400
On Oct 1, 2007, at 21:52, Stan Cleveland wrote:
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.
It was not my clever idea, it was Microsoft's.
It puts a function that gets you all excited, but it does not work!
:)
"We're lost, but we're making good time!" :-)
The above is probably their slogan...
:)
Deivy
_______________________________________________
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