How to autosave excel template

Thread Starter


Joined Oct 26, 2010

I made an excel template to capture some data in the computer, and it is running automatically after i turn on the computer. i want it to auto save the file and i set the autosave in excel, but because it is a template so when it is saving the data it always ask me if i want to create the new file.
I am thinking maybe i can add come code in the vba to create the file and save the data automatically?
Can anyone help me with this?
Last edited: