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).

How To Automatically Run Excel VBA Macros Daily — TheSpreadsheetGuru

Learn how to utilize a few programs you already have to create automation rules that will automatically open up your Excel files, run VBA code, save the changes, and then close the file. These automations can even be setup to run while you sleep!

www.google.fr

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