How to autosave excel template

Discussion in 'Programmer's Corner' started by chudiandeyu, Nov 25, 2011.

  1. chudiandeyu

    Thread Starter Member

    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: Nov 25, 2011