|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Trouble with Excel Macro called from ASP
Hello, first sorry about my english.
Iīve the next situation in an Excel Macro. It works fine executed from the Excel file on the server. It creates a PDF file. Itīs necessary to add the "Acrobat Distiller" reference to the Excel VBA Proyect. Sub PDFReports() Dim PSFileName As String Dim PDFFileName As String Dim myPDF As PdfDistiller Set myPDF = New PdfDistiller PSFileName1 = "Competitor.ps" PDFFileName1 = "Competitor.pdf" Application.DisplayAlerts = False 'Print the Excel range to the postscript file Range("Competitor").PrintOut copies:=1, preview:=False, ActivePrinter:="Adobe PDF", printtofile:=True, collate:=True, prtofilename:=PSFileName1 'Convert the postscript file to .pdf myPDF.FileToPDF PSFileName1, PDFFileName1, "" End Sub The problem is that when I try to executed it via ASP it doesnīt work (the Excel instance does not desapear from the TaskManager). Itīs not a problem from ASP calling because others macroīs call work fine, so there should be a trouble in the VBA code. Does anyone know why it does not work? Thank you very much. |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Trouble with Excel Macro called from ASP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|