Instead of opening the XL file directly, have the Scheduler run a samall
VB
script which creates an Excel appplication instance (using createobject) and
then opens the file in that instance. Unless you explicitly set
visible=true on the Excel application instance, you shouldn't see it.
Tim
"Sri via OfficeKB.com" <u47062@uwe wrote in message
news:8f165df5fe937@uwe...
Hello,
I prepare one macro and placed it "Workbook_Open()" and at the end, I said
"Me.Save" and "ActiveWorkbook.Close" to close the workbook.
I created a scheduled task with the "Scheduler" (in control panel) to open
the above XL file once in every 30 minutes.
When ever this file is opened by "Scheduler", I see a new XL window
opening
in my task bar and closes after the macro is finished.
Is there a way I can hide this XL window so that user does not know about
it
at all.
Thanks
Sri
--
Message posted via http://www.officekb.com