Hello ,

I am using WIn32::OLE to Read contents of an Excel sheet.
There is no issues on reading, but the problem is that Excel file opens on the screen, durin
g the time the script processes the file.

I don't need this.
One solution was to make it not visible ($Excel-> {'Visible'} = 0;).
But this had some other problems. In some cases, when this Excel sheet was open for viewing,
 its contents were hidden ! , when we move the mouse over the cells, then we see it .. might
 be a Excel Bug. Due this we cannot make the Excel sheet invisible during the runnign of the
 script.

What I need now is to minimise the sheet once it is opened. How do we do it ?

My code extract -

use Win32::OLE::Const 'Microsoft Excel';

$Excel = Win32::OLE-> GetActiveObject('Excel.Application')|| Win32::OLE->new('Excel.Applicati
on', 'Quit');

$Excel-> {'Visible'} = 1;

$xlFile = 'C:\HWEConfig.xls';

eval { $Book = $Excel-> Workbooks->Open("$xlFile"); };

... then the reading ....






Thanks and Regards
Maxmelbin Neson