Darth_Alicious
New Member
- Joined
- Apr 24, 2017
- Messages
- 4
Hello all,
I am attempting to create an Excel VBA Macro for my job to:
1. Fill a fillable PDF from an Excel Table
2. Save a copy as "filename.pdf" (The filename in question comes from a specific cell in the excel table).
3. Print that copy to PDF in a different folder using Adobe PDF (to render it non-fillable) as "filename_copy.pdf"
4. Loop the process.
I have everything down except for the "print to pdf" part. The fillable PDF fills and saves just fine. I have the following line in my program:
This works to print the created PDF, but it asks me to name the file every time. My question is: Is it possible to automatically print to PDF from Excel and have the doc named "filename_copy.pdf", either from the existing PDF being printed, or from the same cell in Excel as the first PDF gets its name?
To clarify, I am NOT printing a paper copy, I am using Adobe PDF as a printer to create a second PDF that loses the fillable fields.
Thank you!
I am attempting to create an Excel VBA Macro for my job to:
1. Fill a fillable PDF from an Excel Table
2. Save a copy as "filename.pdf" (The filename in question comes from a specific cell in the excel table).
3. Print that copy to PDF in a different folder using Adobe PDF (to render it non-fillable) as "filename_copy.pdf"
4. Loop the process.
I have everything down except for the "print to pdf" part. The fillable PDF fills and saves just fine. I have the following line in my program:
Code:
objAcroAVDoc.PrintPages 1, 2, 2, True, TrueThis works to print the created PDF, but it asks me to name the file every time. My question is: Is it possible to automatically print to PDF from Excel and have the doc named "filename_copy.pdf", either from the existing PDF being printed, or from the same cell in Excel as the first PDF gets its name?
To clarify, I am NOT printing a paper copy, I am using Adobe PDF as a printer to create a second PDF that loses the fillable fields.
Thank you!
