troubles with Win32::OLE

[readey]

Hi peeps,

I'm using Win32::OLE to open a load of excel files - I nees to read two cells, one with a date and the other with a time. My program seems to have trouble closing each instance of excel.

I use $obj = Win32::OLE->new(Excel.Application, 'Quit');
and at the end I also use;
$obj->close at the end.

Does the close method apply to the workbook as opposed to the instance of excel, can I just start one instance of excel and open / close the files I want?

regards,

readey

 

[dmazzini]

You just need to:

1. create one time Excel Object
2. open workbook -> worksheet. A
3. close workbook



dmazzini
GSM/UMTS System and Telecomm Consultant