VBA PDF Print

[Torsten1]

Hello,

I need help accessing external PDF files and printing them. I currently have the following workflow:I have to fill out a PDF form with form details and save it as a new PDF. Since I don't (can't) use Acrobat, I have to print the PDF using a PDF printer. With this I want to save the new PDF at a specific location.Almost everything works except saving again.

I can view or print the PDF.

- Create and save FDF file
- Rename FDF file to PDF
- Open PDF

But don't print PDF with save without displaying the save dialog. I use PDFX-Change as a PDF printer.With the following code I call up the PDF file for display
ShellExecuteA 0&, "Open", "c:\Test\Antrag.pdf", vbNullString, vbNullString, SW_SHOWMINNOACTIVE

or for printing

ShellExecuteA 0&, "Print", "c:\Test\Antrag.pdf", vbNullString, vbNullString, SW_SHOWMINNOACTIVE

Can someone help me?


VG

Torsten

 

[John_w]

It's not clear to me which part of your workflow you want to automate with VBA and which part you've already got the code for.

I have to print the PDF using a PDF printer. With this I want to save the new PDF at a specific location.

A PDF printer 'prints' a file to a .pdf file, usually displaying a Save dialogue for the user to choose a location and file name. But if you already have a .pdf file, why do you need to 'print' it to another .pdf file? Can't you just copy it to a specific location and .pdf file name?

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: I need help accessing external PDF files and printing them.
and PDF Print with ShellExecuteA
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.