Save a file with the path and the filename coming from a specific folder and cell address; Print a specific sheet.

[mad4max]

Hi everybody…

I’m a newbie in VBA and I have a recurrent problem.

I like to have a folder called: “Param” in which I setup several parameters that I can reuse later.

Example of the sheet PARAM as showed in attached image.

I need now the following macros:

• A macro to safe the file in Excel format, in the folder specified in the cell C13 from the folder PARAM, with the filename specified in the cell C14;
• A macro to safe the file in PDF format, in the folder specified in the cell C15 from the folder PARAM, with the filename specified in the cell C16;
• A macro to print the Worksheet Recap-CA-N1, which name is specified in the cell C19, as it. The print option are defined in the worksheet itself;
• A macro to save in PDF the Worksheet Recap-CA-N1, with the same name as specified in the cell C19, in the folder specified in the cell C15 from the folder PARAM.

Thank you for your always valuable help.