Thank you - this is exactly what I needed

JLGWhiz wrote:
While the workbook you want backup is open and is the active workbook, you
can set a variable to its path.

myPath = ActiveWorkbook.Path

Then use that variable in the SaveAs command as part of the file name.

ActiveWorkbook.SaveAs Filename:=myPath & "\<backupname.xls?"

backupname would be the actual name you give to the backup file and the file
extension would be based on the format to which you want to save the file.
It is better to use the actual workbook name instead of ActiveWorkbook in
case that workbook is not active at the time you decide to initiate the path
variable or do the saveas.

I have a file that I update each day and then it is updated by others. (Not
a
[quoted text clipped - 9 lines]

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201005/1