• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Need Excel AppleScript for Office 2004 for Macintosh
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: Need Excel AppleScript for Office 2004 for Macintosh
      • From: deivy petrescu <email@hidden>
References: 
 >Re: Need Excel AppleScript for Office 2004 for Macintosh (From: Stan Cleveland <email@hidden>)

  • Prev by Date: Re: Need Excel AppleScript for Office 2004 for Macintosh
  • Next by Date: Re: Need Excel AppleScript for Office 2004 for Macintosh
  • Previous by thread: Re: Need Excel AppleScript for Office 2004 for Macintosh
  • Next by thread: Re: Need Excel AppleScript for Office 2004 for Macintosh
  • Index(es):
    • Date
    • Thread