Automatically ran macro

[AutoMacroGuru]

Hello,

I am looking to have a macro ran periodically on a spreadsheet. In order to achieve such a goal, I based myself on a post I saw from The Spreadsheet Guru (link below).

Redirect Notice

unfortunately, my macro modifies the file and I am asked if I want to save the changes. Does anyone know if there’s a line I can add to preclude the VBscript from asking me this? I am not supposed to have anything to do, the script is supposed to do all the work, that’s the whole point ?.

regards,
AutoMacroGuru

 

[sykes]

To close & save changes (without the user being prompted):

activeworkbook.Close  true

... and don't save:

activeworkbook.Close  false