Server 2009

Automate Printing with Excel

Example code is for an older version of Server, newer code is available.
' Copyright (c) 2019 ActivePDF, Inc.
' ActivePDF Server 2009
' Example generated 11/20/19 

Dim FSO, strPath, intStartPrinting, intWait

' Get current path
Set FSO = CreateObject("Scripting.FileSystemObject")
strPath = FSO.GetFile(Wscript.ScriptFullName).ParentFolder & "\"
Set FSO = Nothing

' Instantiate Object
Set oSVR = CreateObject("APServer.Object")

' Path and filename of output
oSVR.OutputDirectory = strPath
oSVR.NewDocumentName = "Output.pdf"

' Start the print job
intStartPrinting = oSVR.StartPrinting()
If intStartPrinting <> 0 Then
  ErrorHandler "StartPrinting", intStartPrinting
End If

' Automate Excel to print a document to activePDF Server
Set objXLS = CreateObject("Excel.Application")
objXLS.DisplayAlerts = False
Set objDoc = objXLS.Workbooks.Open (strPath & "excel.xls", , True, , , , True, , , False, False, , False)
objDoc.Activate
objDoc.PrintOut 1, 999, 1, False, oSVR.NewPrinterName, False, False
objDoc.Close 0
objXLS.Quit
Set objDoc = Nothing
Set objXLS = Nothing

' Wait(seconds) for job to complete
intWait = oSVR.Wait(30)
If intWait <> 0 Then
  ErrorHandler "Wait", intWait
End If

' Release Object
Set oSVR = Nothing

' Process Complete
Wscript.Echo("Done!")

' Error Handling
Sub ErrorHandler(method, outputCode)
  Wscript.Echo("Error in " & method & ": " & outputCode)
End Sub

Copyright © 2019 ActivePDF, Inc