Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^2: Making workbook visible with Excel 2013

by Anonymous Monk
on Feb 26, 2015 at 20:38 UTC ( [id://1117991]=note: print w/replies, xml ) Need Help??


in reply to Re: Making workbook visible with Excel 2013
in thread Making workbook visible with Excel 2013

The object model seems to be the same on old versus new Excel. If you record a VBA macro to unhide a workbook with this version of Excel you basically get:
Windows("workbook_name.xls").Visible = True
Which is what you get on earlier versions. Oddly, Visible does not appear to be a property of Windows in either version of Excel, so maybe it should have never worked. The way I was doing it was right out of Dave Roth's book. There's got to be a way with the current version of Excel to accomplish this!

Replies are listed 'Best First'.
Re^3: Making workbook visible with Excel 2013
by chinman (Monk) on Feb 26, 2015 at 21:11 UTC
    ^^^Oops, that was my post above, forgot to login first!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1117991]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (4)
As of 2024-04-23 20:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found