Auto save workbook every 8 hours

[chopperprop]

I currently have a work book that the cells are tied to links from a PLC , and I have set the save function to every 60 min added in the work network location in the correct spot and also mapped the network drive and added the location into the trusted locations.
I does not save automatically but it does save with the file save as . So manually saving it works.
I would like to auto save this workbook to my network location every 8 hours.

I have checked through the forums and can not find a similar request.
Thank You

 

[nemmi69]

Have a look at https://www.mrexcel.com/forum/excel-questions/80363-autosave-vba.html

 

[chopperprop]

I get error can not run macro as macro may be disabled or not available in workbook. I check macro security and it is set to allow all

 

[chopperprop]

so far i have tried disabling all security settings and also redirected the save location to the original settings on the local system , I have the workbook macro installed in the VBA editor for the entire workbook. I am running the save it code and changed it to 1 min and also tried 2 min for troubleshooting , I still get the not macro enabled workbook error that pops up each time the code tries to write the saved file.

 

[chopperprop]

The work book is the correct format .xlsm