This is going to be so easy for you guys to answer...

Feb 21st, 2002, 07:42 AM

OK, I know a lot of people ask macro questions, but can someone just answer me this quick one. How do I record a macro so that everytime I click it, it saves the workbook in a folder but gives it a name different from the other files. For instance, the first time I click it, it will save the workbook as "1", then the next time I click it it will save it as "2" and so on. Is this possible, and if so, is there a way to get it to save it as the current date?

Juan Pablo González · Feb 21st, 2002, 08:11 AM

ActiveWorkbook.SaveAs Filename:=Format(Date,"dd-mm-yyyy") & ".xls"

Feb 21st, 2002, 08:11 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	ActiveWorkbook.SaveAs Filename:=Format(Date,"dd-mm-yyyy") & ".xls" __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 07:42 AM	#1
Guest Posts: n/a	OK, I know a lot of people ask macro questions, but can someone just answer me this quick one. How do I record a macro so that everytime I click it, it saves the workbook in a folder but gives it a name different from the other files. For instance, the first time I click it, it will save the workbook as "1", then the next time I click it it will save it as "2" and so on. Is this possible, and if so, is there a way to get it to save it as the current date?