http://qs1969.pair.com?node_id=389916


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.