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: Bert Groeneveld <email@hidden>
- Date: Fri, 31 Jul 2009 21:29:20 +0200
Hello Tom, I tested Paul's script with:
Excel 2004: It errors at line 8 with this message: Microsoft Excel got
an error: used range of active sheet doesn’t understand the get resize
message.
Excel 2008: Script runs into a timeout error. And I need to force quit
Excel 2008.
I guess it has something to do with the Excel document itself.
Paul, can I send you the Excel file to test?
Bert.
On 30 jul 2009, at 23:46, Thomas Maffucci wrote:
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 (applescript-
email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden
_______________________________________________
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