Hi guys, new member here. I am working with a excel workbook that is 100+ pages, and requires that each month we save each sheet as the sheet name, followed by the last date it was updated, in PDF form. An example of this would be a sheet called Wegmans, which is updated today (8-19-2011). I need to have that sheet saved in PDF form with a file name reading Wegmans 8-19-2011, and be saved in its own unique folder that houses all the previous versions. To do this with every client takes 2-3 hours each month, and is something I know can be done with one click from a Macro.
I've been going through Domski and Widdman50's old threads but can't seem to move past error messages.
Any help would be greatly appreciated.
Joe
I've been going through Domski and Widdman50's old threads but can't seem to move past error messages.
Any help would be greatly appreciated.
Joe
