View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Execute XL invisible

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