Hi I have tried to record to following steps in a macro but Im failing when it comes to certain steps. I think more “advanced” vba is needed !

OK, so there is 3 step I want to preform with the one click of a button.

STEP 1: Set the print area (based on my current selection)

STEP 2: Save as .xslx (currently its a .xlsm as there is other macros) Now here is the thing… I have text in a cell on a different sheet and I want this “cell value/text” as the file name.

STEP 3: Now print this to .pdf (Adobe not cute pdf etc..) this .pdf will need to have the same name as the .xls but this happens anyway as the workbook will be saved in step 2.

Any help is greatly appreciated. I carry out this task every day about 500 times !

Thanks,

Paul.