Recording macro to save file with name change
I have recorded a macro that will make multiple formatting changes to a .csv
file and then save it in a new directory. The newly created file will have a new file name each day based on the current date. For example, todays new file is "Outbound 02-22-07" and tomorrows will be "Outbound 02-23-07" etc. But when I look in the VBA editor, the code is specific to the file name at the time the macro was recorded. Is there a way to have the macro save it with a variable filename as I have outlined above? Any help would be appreciated - this is my jump into using macro's. With Best Regards, Jon |
Recording macro to save file with name change
replace the line with the hard-coded filename to something like:
ActiveWorkbook.SaveAs "Outbound " & Format (Now, "mm-dd-yy") On Feb 22, 2:38 pm, jmcclain wrote: I have recorded a macro that will make multiple formatting changes to a .csv file and then save it in a new directory. The newly created file will have a new file name each day based on the current date. For example, todays new file is "Outbound 02-22-07" and tomorrows will be "Outbound 02-23-07" etc. But when I look in the VBA editor, the code is specific to the file name at the time the macro was recorded. Is there a way to have the macro save it with a variable filename as I have outlined above? Any help would be appreciated - this is my jump into using macro's. With Best Regards, Jon |
Recording macro to save file with name change
activeworkbook.SaveAs "C:\Myfolder\Outbound " & format(date,"mm-dd-yy") &
".csv", xlCSV or to save it as a workbook: activeworkbook.SaveAs "C:\Myfolder\Outbound " & format(date,"mm-dd-yy") & ".xls", xlWorkbook -- Regards, Tom Ogilvy "jmcclain" wrote: I have recorded a macro that will make multiple formatting changes to a .csv file and then save it in a new directory. The newly created file will have a new file name each day based on the current date. For example, todays new file is "Outbound 02-22-07" and tomorrows will be "Outbound 02-23-07" etc. But when I look in the VBA editor, the code is specific to the file name at the time the macro was recorded. Is there a way to have the macro save it with a variable filename as I have outlined above? Any help would be appreciated - this is my jump into using macro's. With Best Regards, Jon |
All times are GMT +1. The time now is 08:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com