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