RE: WIN32::OLE help

2008-08-18 Thread Brian Raven
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neson Maxmelbin (RBEI/EMT4) Sent: 18 August 2008 09:40 To: Steve Howard (PFE); perl-win32-users@listserv.ActiveState.com Subject: RE: WIN32::OLE help > Hello Steve, > > It does work and my machine shows the same values for

RE: WIN32::OLE help

2008-08-18 Thread Neson Maxmelbin (RBEI/EMT4)
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Howard (PFE) Sent: Friday, 15. August 2008 1:34 AM To: Neson Maxmelbin (RBEI/EMT4); perl-win32-users@listserv.ActiveState.com Subject: RE: WIN32::OLE help I'll type this directly in so I might make a

RE: WIN32::OLE help

2008-08-14 Thread Steve Howard (PFE)
I'll type this directly in so I might make a typo. You should be able to set the state in the application object: $Excel->{WindowState} = -4140; To set back to normal mode: $Excel->{WindowState} = -4143; The way to find this is to record a macro in Excel, and do what you want to see. Then vie

Re: WIN32::OLE help

2008-08-14 Thread ekkehard . goerlach
Hello, if you just want to read data from an Excel file, you might consider the Spreadsheet::ParseExcel module. I would think that using the OLE module always starts an Excel instance (visible or not) whereas the Spreadsheet module operates directly on the XLS file. Ekkehard