Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chicateer

    Using Perl to access Excel File

    yes, I am able to open workbooks that do not have a password, it's the one's with the password that fail me. You can get OLE related documentation from the ActiveState site http://aspn.activestate.com/ASPN/docs/ActivePerl/OLE-Browser/Browser.html
  2. chicateer

    Using Perl to access Excel File

    yes, it fails on all workbooks - Did not quite understand your comment of using the Excel::Workbook over ActiveX objects. Would appreciate some further details thanks
  3. chicateer

    Using Perl to access Excel File

    Paul, thanks for your response. I enclose a sample version of the code that keeps failing Appreciate any help that you can give on this one. thanks, use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; $Win32::OLE::Warn = 3; # die on errors...
  4. chicateer

    Using Perl to access Excel File

    I am trying to read an Excel file that has a password. When I use the Workbooks->Open(filename,,,,password,) statement, i get an error ""unable to get the Open property of the Workbooks class" any help would be appreciated thanks

Part and Inventory Search

Back
Top