Here is a backup macro that I use that should give you an idea. The key word
here is .savecopyAS

Sub Backup() 'kept in personal.xls & assigned to toolbar button
On Error GoTo BackupFile
MkDir CurDir & "\Backup"
BackupFile:
With ActiveWorkbook
MyWB = .Path & "\BACKUP\" & .Name
.SaveCopyAs MyWB
.Save
End With
End Sub
--
Don Guillett
SalesAid Software

"Baddad007" wrote in message
...
I have developed an Excel sheet with built-in formulas for checking
balance figures quickly. I would like to be able to design a macro that
would create a new copy of the spreadsheet, with current figures and a
unique time-date stamp name, without changing the original copy. I have
tried, but my original keeps changing to match my copy. Any ideas?
Thanks,


---
Message posted from http://www.ExcelForum.com/

I have developed an Excel sheet with built-in formulas for checkin
balance figures quickly. I would like to be able to design a macro tha
would create a new copy of the spreadsheet, with current figures and
unique time-date stamp name, without changing the original copy. I hav
tried, but my original keeps changing to match my copy. Any ideas?
Thanks,

--
Message posted from http://www.ExcelForum.com