one4youman
New Member
- Joined
- Oct 5, 2018
- Messages
- 13
Hi,
I am trying to find a way to print / export several sheets from a workbook as a PDF and to then combine the new PDF to an existing PDF.
My thought process is this:
1. Print / export several sheets from a workbook and save the PDF in a temporary folder.
2. A dialog box would then open asking you to browse to the existing PDF that you wish to combine with the previously created temporary PDF.
3. A dialog box would open prompting you to browse to where you would like to save and to name the merged file.
4. Clean up and delete the temporary PDF.
I have tried several different codes and have not had much luck finding a solution to the above. Most of the codes I have found rely upon entering the file path and names in cells which I am trying to avoid.
Thank you in advance for any assistance,
John
I am trying to find a way to print / export several sheets from a workbook as a PDF and to then combine the new PDF to an existing PDF.
My thought process is this:
1. Print / export several sheets from a workbook and save the PDF in a temporary folder.
2. A dialog box would then open asking you to browse to the existing PDF that you wish to combine with the previously created temporary PDF.
3. A dialog box would open prompting you to browse to where you would like to save and to name the merged file.
4. Clean up and delete the temporary PDF.
I have tried several different codes and have not had much luck finding a solution to the above. Most of the codes I have found rely upon entering the file path and names in cells which I am trying to avoid.
Thank you in advance for any assistance,
John