AutoMacroGuru
New Member
- Joined
- Aug 19, 2020
- Messages
- 4
- Office Version
-
- 365
- Platform
-
- Windows
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).
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
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!
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