I have 7 sheets in a workbook that I need to save as separate files. I can do it either as HTML or PDF but I cannot seem to get coding to work. I am new to VBA. I have searched and checked with some VBA trained people and no one can seem to get a code that works.

I set up cell A1 on each sheet to be the file name, minus the file extension. As an example - the sheet named "Admin" in cell A1 = "Admin8202014" this way I can have the name and date in the file name for each sheet. I have the print area set up for each of the 7 sheets.

Can anyone help with this? Is this even possible?