Re^8: Generating reports from Databases

one more small question... in my perl script I am using this module 'use Win32::OLE::Const 'Microsoft Excel' to create excel spreadsheets. I have noticed that in order for the functions to work and create the workbooks/worksheets that the application has to be running at the background. IS there any way that I can do this without excel running? Am I doing something wrong or do I still need to add something to my code. The aim for this script is to run at scheduled times, thus it is quite possible that excel won't be running at the time. Thank you in advance

Comment on Re^8: Generating reports from Databases

Replies are listed 'Best First'.
Re^9: Generating reports from Databases by planetscape (Chancellor) on Jul 09, 2007 at 14:25 UTC
Perhaps you might want to post the entirety of the code you are using. That way, it is much easier for Monks to review and suggest corrections/improvements. Of course, we have now disgressed so far from the original question in this thread that it might be in your best interests to post a new SoPW including your code. I have automated Excel from VB(A)? rather extensively, but rarely from Perl (so far). Yes, Excel does need to be running in order to automate it; I've always used code that makes sure to start Excel if an instance is not already running. So you may wish to investigate how Win32::OLE could do that for you, or possibly look into using the Windows scheduling service. HTH, planetscape	[reply]

Replies are listed 'Best First'.

Re^9: Generating reports from Databases
by planetscape (Chancellor) on Jul 09, 2007 at 14:25 UTC

Perhaps you might want to post the entirety of the code you are using. That way, it is much easier for Monks to review and suggest corrections/improvements. Of course, we have now disgressed so far from the original question in this thread that it might be in your best interests to post a new SoPW including your code.

I have automated Excel from VB(A)? rather extensively, but rarely from Perl (so far). Yes, Excel does need to be running in order to automate it; I've always used code that makes sure to start Excel if an instance is not already running. So you may wish to investigate how Win32::OLE could do that for you, or possibly look into using the Windows scheduling service.

HTH,

planetscape

[reply]