in reply to Win32::OLE - Excel, Can't save as Previous Version

Opps I was missing
use Win32::OLE qw(in with); use Win32::OLE::Variant; use Win32::OLE::Const 'Microsoft Excel';

Replies are listed 'Best First'.
Re^2: Win32::OLE - Excel, Can't save as Previous Version
by davies (Monsignor) on Aug 25, 2011 at 15:11 UTC

    Oopser - much, much oopser - you are missing

    use strict; use warnings;
    Life's too short for me to try to put everything needed by strict in for you, but I can see several potential problems. Perhaps the most likely is that Excel may be putting up a dialogue box when it tries to save (it certainly would if the file exists already or the directory is mis-spelled or ...), but since you have Excel hidden (why?), you can't see it. And since you don't have warnings, Perl won't tell you. Of course, it's possible that there's a simple typo somewhere that strict would pick up as well or instead.

    Regards,

    John Davies