Macro to create a PDF of an external excel workbook

[davidalldred]

Hi peeps, I am pretty sure that this can be done, but I have no idea where to start so I am hoping someone here can.

What I would like to have is a macro-enabled workbook that will allow you to select another workbook with multiple worksheets and either save it as a PDF or print it to a PDF.

My thoughts of a solution would be to have a Macro Workbook that you open, and you would either put the address into a cell and run the macro or you run the macro and a pop up window opens up and you go to the workbook file location that you want to print to PDF. It would then create, save and open the PDF so that it can be checked.

I know how to create a macro to do this within a workbook, but I don't want to make it into a macro-enabled workbook.

I don't have any examples to attach as it's just an idea I have to make it easy to create PDFs.

Thanks in advance for any solutions.

Dave.

 

[mumps]

You are very welcome.