How to Run Excel Macros from ASP

[Chain-SmokeR]

Hello Friends,
am currently working with a project which is basically in a Asp platform,for that I need to call an existing Excel macro from ASP.for example

Set objExcel = New Server.create object("Excel.Application")
....................
....................
....................
objExcel.Run("macro-name")

but it fails to run..i need to get some inputs to succeed I understand that my ASP doesn't seem to understand Excel.Application and .Run command.
any help would be greatly received ...
thanks for reading me

[opaper]

I was in search for a remedy to this and I finally some inputs it but i don't know what about your exact situation
For this I created a macro in the Excel file:

Sub PAll()
Application.ActivePrinter = "\\SERVER\Printername on Ne02:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Application.Quit
End Sub

I have exhausted consider amount of time to get a better output
Dim xls
Set xls = CreateObject("Excel.Application")
xls.Application.Visible = False
' 3 is the value for "xlReadOnly"
xls.Workbooks.Open ExcelFilePath, 3, False
xls.Run("ThisWorkBook.PAll")
Set xls = Nothing
while your Macro does not have a command to quitthe application
xls.Application.but you need to Quit before setting the var to nothing.

[MindSpace]

have you tried tried New server.createobject, New createobject Server.CreateObject though that would not make a difference.
If you need you can peer at the permissions of the folder that the excel file had....