View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sri via OfficeKB.com Sri via OfficeKB.com is offline
external usenet poster
 
Posts: 20
Default Execute XL invisible

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