topic Re: PDF printing using VBA in VBA Forum

PDF printing using VBA

Anonymous — Mon, 10 Aug 2020 13:12:13 GMT

Hi all,

I am new to VBA. I need help to write VBA code in AutoCAD'18 to print PDF file which is store stored on my PC, by setting the following parameters of printer,

1. Printer name

2. Orientation

3. Paper size (A3/A4)

4. Print on both sides of paper (either Flip on long edge or Flip on short edge)

5. Pages to print (All)

Can someone please help me to get the VBA code for above requirement? Your help is highly appreciated.

Re: PDF printing using VBA

Ed__Jobe — Tue, 11 Aug 2020 14:50:00 GMT

This is an old subject. If you search this forum for "plot" or "plotconfig", you should find plenty of code samples.

Re: PDF printing using VBA

Anonymous — Thu, 13 Aug 2020 11:10:01 GMT

Hi,

I have written the following code, which I expect to open the PDF file and send it to printer. It is opening the PDF file, but printer code is not working. can Someone Please help me?

Sub PrintPDFFile()

Dim ObjShell As Object
Dim path As String
Dim DrgPrintMgr As Printer

path = "C:\Users\Desktop\Print\L00G92N-T.pdf"
Set ObjShell = CreateObject("Shell.Application")
ObjShell.Open (path)

With ObjShell
Set DrgPrintMgr = File.PrintManager
With DrgPrintMgr
.Printer = "\\pu3insvns01\PU3INP01"
.AllColorsAsBlack = True
.ColorMode = kPrintGrayScale
'.ScaleMode = kPrintBestFitScale
.PaperSize = kvbPRPSA3
'.PaperSize = [vbPRPSA4]
.PrintRange = kPrintAllSheets
.Orientation = kLandscapeOrientation
.RemoveLineWeights = False
.SubmitPrint
End With
End With

End Sub

Re: PDF printing using VBA

Ed__Jobe — Thu, 13 Aug 2020 14:38:23 GMT

What library does your project reference that has a PrintManage object? You use a File object but don't set an instance of it. When the file opens, what program does it open in? You need to use that program's api (if it has one) to print the file.

Re: PDF printing using VBA

Anonymous — Fri, 14 Aug 2020 13:35:20 GMT

Hi Ed.Jobe

When the document open, it opens in the "Adobe Acrobat DC" . Can you please help me with "Adobe Acrobat DC" API's to print PDF file?

Re: PDF printing using VBA

Ed__Jobe — Mon, 17 Aug 2020 14:57:06 GMT

I checked and Reader doesn't have an api. If you bought the pro version it might.