excel VBA save file
 

Could anybody help me create a solution for:

I have created a excel workbook. This is a masterworkbook in which
calcualtions are being provided. Eaqch time a user uses this workbook
he should make a copy of this workbook to archive it. In the workbook i
have added the name of the file i want it to be saved as.
Does anybody have a suggestion for visual basic code?


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

excel VBA save file
 

See my backup page
http://www.mvps.org/dmcritchie/excel/backup.htm
at least to get you started.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Wesselius " wrote in message ...
Could anybody help me create a solution for:

I have created a excel workbook. This is a masterworkbook in which
calcualtions are being provided. Eaqch time a user uses this workbook
he should make a copy of this workbook to archive it. In the workbook i
have added the name of the file i want it to be saved as.
Does anybody have a suggestion for visual basic code?


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