Re: Excel (2004) Hidden rows show up in tab delimited text file
Re: Excel (2004) Hidden rows show up in tab delimited text file
- Subject: Re: Excel (2004) Hidden rows show up in tab delimited text file
- From: Thomas Maffucci <email@hidden>
- Date: Thu, 30 Jul 2009 17:46:38 -0400
- Thread-topic: 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