<!-- Copyright (c) 2019 ActivePDF, Inc. -->
<!-- ActivePDF Server 2013 -->
<!-- Example generated 10/22/19 -->
<%
Dim strPath, results
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
Set results = oSVR.BeginPrintToPDF()
If results.ServerStatus <> 0 Then
ErrorHandler "BeginPrintToPDF", results, results.ServerStatus
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
Set results = oSVR.EndPrintToPDF(30)
If results.ServerStatus <> 0 Then
ErrorHandler "EndPrintToPDF", results, results.ServerStatus
End If
' Release Object
Set oSVR = Nothing
' Process Complete
Response.Write "Done!"
' Error Handling
Sub ErrorHandler(method, oResult, errorStatus)
Response.Write("Error with " & method & ": <br/>" _
& errorStatus & "<br/>" _
& oResult.details)
Response.End
End Sub
%>
