Auto save additional copy with date as name

Hi very new to macros so please forgive me if this is either stupid or not possible.

I have an 'accounts' WB that i store all business transactions on. Previously when ever we have entered new data we simply 'save as' and edit the date to the filename, this ensures back-ups of the file and obviously we can easily go back and see any changes made between versions.Fine no problem, now the thing is as my knowledge of excel has grown im learning the power of Vlookup between WB's however my current method would not work as the vlookup function would always refer to an outdated version of the file, im sure you get the point. So, is there a way keep the file name the same everytime i save the file but also save a duplicate file labelled with the date that its being saved and save to a speceifc folder? thus having back up files everytime we make new entries. I should probably add this is all stored on dropbox and i dont know if this causes a problem?

Any advice much appreciated.

Try the 'CreateBackupFile()' Macro below. It saves the the backup file in
the same folder as the 'Active Workbook'. This can be easily modified to suit your needs.

Please Login or Register  to view this content.

Originally Posted by LJMetzger

Try the 'CreateBackupFile()' Macro below. It saves the the backup file in
the same folder as the 'Active Workbook'. This can be easily modified to suit your needs.

Please Login or Register  to view this content.

Im so sorry but this is all another language to me. The file is called <AGL Accounts 2013-14> and its location is :Dropbox-AGL-Accounts-2013-14 can anyone help me complete this macro with these details? Thanks in advance.

I am not familiar with how to access 'Dropbox'. You may have to change the 'sPath' below to something like 'D:\Dropbox\' or however you access 'Dropbox' from your computer.
In the Macro I posted you have to do something like the following:

Replace:

Please Login or Register  to view this content.

With:

Please Login or Register  to view this content.

Originally Posted by LJMetzger

I am not familiar with how to access 'Dropbox'. You may have to change the 'sPath' below to something like 'D:\Dropbox\' or however you access 'Dropbox' from your computer.
In the Macro I posted you have to do something like the following:

Replace:

Please Login or Register  to view this content.

With:

Please Login or Register  to view this content.

Thanks for your help! And do I use a hyphen(-) as the separators for file path?

Originally Posted by alfgrey

Thanks for your help! And do I use a hyphen(-) as the separators for file path?

I don't know. I copied the links from your post. My speculation is that you can use a "\" and access 'Dropbox' as a virtual disk attached to your Computer. It will probably take some frustrating trial and error.

Lewis