View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Execute XL invisible

I don'tt believe so. XL needs to open at least enough to run your worksheet,
so even if you use
application.screenupdating=false
you'll still see the application open.

Also, what you're describing is very similar to what a virus would do, thus
reinforcing my belief that this can not be done.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sri via OfficeKB.com" wrote:

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