Example code is for an older version of Server, newer code is available.
' Copyright (c) 2021 ActivePDF, Inc.
' ActivePDF Server 2009
' Example generated 03/02/21
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