AutoSave When Submitting info on a Userfotm

[jdu007]

Hi folks.

I have created a Userform that transfers data from the form to a worksheet at the click of a button (cmdSubmit).

What I'd like to do at the same time is copy the destination worksheet (or the whole workbook?) to a new folder elsewhere, just in case the original gets accidentally deleted. The Userform will be regularly used, and the destination worksheet will quickly fill up - so I can't afford for it to get lost as I'll have no way of recovering the data.

Any help greatly appreciated.

Thanks!

 

[Jaafar Tribak]

Something like this :

ThisWorkbook.SaveCopyAs "Enter_Your_Full_File_Name_Here"

 

[jdu007]

Hi Jaafar.

Thanks for the response, much appreciated.

However, it doesn't seem to work, but I'm not sure it's due to your code... I'm getting a pop-up box appear, saying Excel cannot access the file, as it either doesn't exist (which it does), is being used by another program (which it's not), or has the same name as the currently open workbook (which it isn't).

Any further help greatly appreciated!

Many thanks in advance,

John.

 

[Jaafar Tribak]

Are you giving the workbook copy a different name from the current workbook name ?
ie: ThisWorkbook.SaveCopyAs "Enter_Your_New_Full_File_Name_Here"