run the macros without opening or showing the excel sheet

[psk]

Hi friends,
I need to find out How we can shedule the wokrbook to run the macros
without opening the excel application.

When i put application.visible = false .

The application is running in the task manger ...without ending
If i use option as "workbook.close"
It's asking " do u want to save the changes in the excel" and also it's
showing the excel application..not the work book ..


Can any one tell me how to write the code for this .?

Thanks

 

[Frank Kabel]

Hi
use
application.displayalerts=false
activeworkbook.save
application.quit
'or
'activeworkbook.close