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

    [download]
    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!
[reply]
[d/l]
[select]
      ^^^Oops, that was my post above, forgot to login first!
[reply]

In Section Seekers of Perl Wisdom