Mailing Lists: Apple Mailing Lists
 Image of Mac OS face in stamp
Re: Excel (2004) Hidden rows show up in tab delimited text file
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel (2004) Hidden rows show up in tab delimited text file

on Wed, 29 Jul 2009 17:21:39 Paul wrote:
>This will replace the original worksheet with the "visibly same" content
>minus the hidden rows. Then save it as a tab delimited file the same way you
>were doing before:


>tell application "Microsoft Excel"
>   set ur to used range of active sheet
>   set visibleRows to {}
>  repeat with eachRow in (get rows of ur)
>      if not hidden of eachRow then set end of visibleRows to item 1 of
>(get value of (contents of eachRow))
>   end repeat
>   set c to count visibleRows
>   set newRange to get resize ur row size c
>   clear range ur
>   set value of newRange to visibleRows
>end tell





Hi Paul
I tried your script on an auto filtered Spread sheet of mine and I got an
Excel crash--"Microsoft Excel got an error: Connection is invalid." on the
first visible data row. The First Visible Title row was ok but the next
visible data row caused this problem. Running MS excel 2008 with update
12.20. I was looking for something like this for some time. I sure hope you
can fix the problem.

Tom Maffucci



 _______________________________________________
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


Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2011 Apple Inc. All rights reserved.