Hi All,
I use one maco to process 6 different reports every morning. Each report has a similar yet unique file name. As an example, report 1 has a file name of "2247 Production Schedule YYMMDD.xls", report 2 has a file name of "7621 Production Schedule YYMMDD.xls" with the number in the file name being the variable and the date format being the current date. Using the same macro, I'm looking to save report 1 in the following format, "2247 Production Schedule YYMMDD_fmtd.xlsb, and reort 2 as "7621 Production Schedule YYMMDD_fmtd.xlsb". Thank you for any help.
I use one maco to process 6 different reports every morning. Each report has a similar yet unique file name. As an example, report 1 has a file name of "2247 Production Schedule YYMMDD.xls", report 2 has a file name of "7621 Production Schedule YYMMDD.xls" with the number in the file name being the variable and the date format being the current date. Using the same macro, I'm looking to save report 1 in the following format, "2247 Production Schedule YYMMDD_fmtd.xlsb, and reort 2 as "7621 Production Schedule YYMMDD_fmtd.xlsb". Thank you for any help.