in reply to Password Protected Excel Files Open while Display set to 0

check for errors
  • Comment on Re: Password Protected Excel Files Open while Display set to 0

Replies are listed 'Best First'.
Re^2: Password Protected Excel Files Open while Display set to 0
by pankaj_it09 (Scribe) on Jan 23, 2009 at 07:19 UTC
    According to the above code the excel files should not get open as display is set to 0.
      But you're not checking for errors
      Win32::OLE->LastError()
      A reply falls below the community's threshold of quality. You may see it by logging in.
      What Excel version are using?
      As this code is based on the deprecated OLE interface, there is a risk that MS has not implemented it properly in newer version.
        I am using Excel 2003.