Script to open file (1 Viewer)

[zezo2021]

Hello
I don't understand in script
but
is there a script o
1- pen excel file every 12 hours
2-run macro
3- then close the file
script run from windows without interaction from the user
Thank you

 

[theDBguy]

Sounds like this would involve using the Task Scheduler.

 

[Isaac]

As dbguy said, use task scheduler.

Either
1) put the code in the excel workbook's Open event (and include a line to save and close the workbook and quit excel at the end)
or
2) use the task scheduler to open a vbscript which automates excel.

 

[zezo2021]