Re: ole for excel 2013 is opening windows

Any clue on what I need to do to restore the Excel 2010 behavior of not opening a window?

I vaguely recall reading on MSDN this is some kind of security feature ... msdn hide excel window

Comment on Re: ole for excel 2013 is opening windows

Replies are listed 'Best First'.
Re^2: ole for excel 2013 is opening windows by rlafetra (Initiate) on Nov 24, 2014 at 04:00 UTC
I didn't get very far with that. However, I did poke more, and discovered a partial solution. With the code below, Perl opens a window briefly (longer than I would like), then minimizes it, which gets me the faster execution time I'm looking for, but leaves it a pain for the user as a maximized window is opened for several seconds... The code is (fragments copied here) use Win32::OLE; use Win32::OLE::Const 'Microsoft Excel'; my $application = Win32::OLE->new("Excel.Application"); my $workbook = $application->Workbooks->Open($pinout); $application->{WindowState} = xlMinimized;	[reply]

Replies are listed 'Best First'.

Re^2: ole for excel 2013 is opening windows
by rlafetra (Initiate) on Nov 24, 2014 at 04:00 UTC

I didn't get very far with that. However, I did poke more, and discovered a partial solution. With the code below, Perl opens a window briefly (longer than I would like), then minimizes it, which gets me the faster execution time I'm looking for, but leaves it a pain for the user as a maximized window is opened for several seconds... The code is (fragments copied here)

use Win32::OLE;
use Win32::OLE::Const 'Microsoft Excel';
my $application = Win32::OLE->new("Excel.Application");
my $workbook = $application->Workbooks->Open($pinout);
$application->{WindowState} = xlMinimized;

[reply]