This is all you really need. It will save any file to the same folder
but a subfolder named backup (even if it doesn't exist). You really
don't need the date, etc. You could put this in the Thisworkbook
module under workbook_open and/or assign to a button or shape

Sub Backup()
On Error GoTo BackupFile
MkDir CurDir & "\Backup"
BackupFile:
With ActiveWorkbook
MyWB = .Path & "\BACKUP\" & .Name
.SaveCopyAs MyWB
.Save
End With
End Sub




On Dec 29, 8:43*am, txheart wrote:
Hi y'all,
I put this on Ozgrid yesterday but it's been over 120 views with no
answers, so I'm copying here - y'all are better anyway!
I've searched over 4 different Excel help forums trying to find a way to
do exactly what I want, but I am just not finding it. Could be I'm
blind, but ...

I run a log of television & appliance returns. That's all it is, just a
log of all the info. Because it has all the info that I need for the
returns (serial, customer, when/if the return was filed, etc.) it is
vitally important to my job. I've had to start from scratch once, and I
don't ever want to have to do that again! The one thing that I've done a
few times is change something & save it, and somehow screwed up
everything else - then I can't remember what was what & where. I make
changes to this log daily, sometimes several times a day.

I want the log, titled RA Sheets & Log, saved in C:/Backup/Log
Backup-mm/dd immediately upon open. That way, any changes I, or anyone
else, make can be easily undone. -Ideally-, I'd be able to actually have
2 backup folders. One that back up every time it's opened & the other
for an automated monthly backup. However, I only actually need the one
backup folder, I can make monthly backups myself.

I would want the last 7 backups in the folder, anything older could be
deleted. In the monthly backup I'd want one every month, like on the 1st
or whatever.

Any help y'all could give me is very much appreciated. I am a VERY
inexperienced VBA & macro user. Since I'm almost 100% certain this
solution will consist of either VBA or macros, or both, I better let you
know to please tell me exactly where to put stuff. Telling me to insert
a module, for example, is just gonna confuse me. lol

Again, anything that y'all can do to help is appreciated. Please let me
know if you have any questions. Thanks!

Ky

--
txheart