Hi Guys,
I want to save a file called workbook.xls, but instead of just saving it I want to archive it as well with a datestamp at the end of it. So today I want to save it as workbook130906.xls, tommorow workbook140906.xls and so on. How can this be done in VBA?
Manish
I want to save a file called workbook.xls, but instead of just saving it I want to archive it as well with a datestamp at the end of it. So today I want to save it as workbook130906.xls, tommorow workbook140906.xls and so on. How can this be done in VBA?
Manish