<!-- Copyright (c) 2021 ActivePDF, Inc. --> <!-- ActivePDF Server 2013 --> <!-- Example generated 03/01/21 --> <% 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 %>