Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Making workbook visible with Excel 2013

by CountZero (Bishop)
on Feb 26, 2015 at 19:42 UTC ( [id://1117987]=note: print w/replies, xml ) Need Help??


in reply to Making workbook visible with Excel 2013

Just a guess, but either $excelapp is not properly initialized or Windows is no longer a method of the Excel object. You will have to check the documentation for the object model of Excel 2013 to make sure.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

My blog: Imperial Deltronics

Replies are listed 'Best First'.
Re^2: Making workbook visible with Excel 2013
by Anonymous Monk on Feb 26, 2015 at 20:38 UTC
    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!
      ^^^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://1117987]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (7)
As of 2024-03-29 09:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found