Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
March 7, 2005, 7:01 pm
rate this thread
Hi, I use Win32::OLE to read in and manipulate data from
Excel files. When I try to SaveAs modified file and then
reopen it I always have to Unhide it.
$wbook = ....
in a loop....
$wsheet->Cells($row_num,$col_num)-> = "$cell_value";
makes $fullname_output_file hidden.
I do not see any property I can set on $wbook to Unhide it
(same way as from Windows menu in Excel).
Thanks for any pointers,
Re: Win32::OLE - Excelo files hidden after SaveAs
>Hi, I use Win32::OLE to read in and manipulate data from
>Excel files. When I try to SaveAs modified file and then
>reopen it I always have to Unhide it.
>I do not see any property I can set on $wbook to Unhide it
>(same way as from Windows menu in Excel).
This is almost certainly an Excel COM problem rather than a Perl one,
which means that you will probably get better help in a Microsoft COM
group rather than here (but you may need to hide the fact that you're
programming the COM object in such a sensible language as Perl!)
But if you Google in the groups for a post entitled "Win32::OLE hiding
Excel sheets" (dated April 2003) you'll see some suggestions.