I need help accessing external PDF files and printing them.

[Torsten]

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

 

[AliGW]

Please read our cross-posting policy: https://excelguru.ca/a-message-to-forum-cross-posters/

As you are new, I shall provide the link for you today: https://www.excelforum.com/excel-programming-vba-macros/1420134-pdf-print-with-shellexecutea.html

Have you posted the same question anywhere else?

 

[Torsten]

Hi,

Of course you try to find help in several places

excelforum.com/excel-programming-vba-macros/1420134-pdf-print-with-shellexecutea.html#post5924667

Vg
Torsten

 

[AliGW]

That's fine, however YOU must disclose this yourself, as per the rules here AND on ExcelForum. Did you read the message in the first link I provided? Your response suggests that you did not.

 

[AliGW]

If you are unwilling to accept our rules and continue to make offensive comments, your membership here will be terminated.

 

[JoePublic]

To be fair, arrogance is a bad quality - especially in someone looking for free help from others who doesn't think rules should apply to them.

 

[AliGW]

Same response on EF, sadly. They clearly don't want to have to bother with rules.