Server 2009

Automate Printing with Excel

Example code is for an older version of Server, newer code is available.
<!-- Copyright (c) 2020 ActivePDF, Inc. -->
<!-- ActivePDF Server 2009 -->
<!-- Example generated 09/21/20  -->

<%
Dim strPath, intStartPrinting, intWait

strPath = Server.MapPath(".") & "\"

' Instantiate Object
Set oSVR = Server.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 = Server.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
Response.Write "Done!"

' Error Handling
Sub ErrorHandler(method, outputCode)
  Response.Write("Error in " & method & ": " & outputCode)
End Sub
%>

Copyright © 2020 ActivePDF, Inc