Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Over a minute to do: use Win32::OLE::Const 'Microsoft Excel';

by iburrell (Chaplain)
on Sep 09, 2004 at 23:08 UTC ( [id://389916] : note . print w/replies, xml ) Need Help??


in reply to Over a minute to do: use Win32::OLE::Const 'Microsoft Excel';

How long does it take to start Excel on the machine? Because that is what the use Win32::OLE::Const  'Microsoft Excel'; line is doing. It loads the 'Microsoft Excel' COM component, which is effectively the Excel application. I am guessing it loads some constants out of the library, but the application startup is where the time goes.

Replies are listed 'Best First'.
Re^2: Over a minute to do: use Win32::OLE::Const 'Microsoft Excel';
by spikey_wan (Scribe) on Sep 10, 2004 at 12:27 UTC
    I'm not doing anything fancy at all in Excel, just running the 2 line script at the top of this thread!

    As for opening Excel normally through windows, well it opens almost instantaneously.