Hi Friends,

Hope you all are doing well.

I want to call an existing Excel macro from ASP.

I see many variations of...

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

but doesn't work.

My ASP doesn't seem to understand Excel.Application and .Run command.

Need help ASAP.

Thanks,

Regards,

What are you error messages?

"The one language all programmers understand is profanity."

In my Excel I have a simple function that inserts 1 into range("A1")
Sub test()
    Range("a1") = 1
End Sub

The ASP script looks like this:
Dim cnnExcel
Set cnnExcel = server.CreateObject("ADODB.connection")
cnnExcel.open "DBQ=" & Server.MapPath("fpdb/book1.xls") & ";" & _
    "DRIVER={Microsoft Excel Driver (*.xls)};"
cnnExcel.Run("test")

With error message:
# Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object 'Run'. Make sure the object exists and that you spell its name and the path name correctly.
/testexcel.asp, line 25

When I try ASP script:
Dim xls
Dim cnnExcel
Set cnnExcel = server.CreateObject("ADODB.connection")
cnnExcel.open "DBQ=" & Server.MapPath("fpdb/book1.xls") & ";" & _
    "DRIVER={Microsoft Excel Driver (*.xls)};"
Set xls = Server.CreateObject("Excel.Application")

The ASP doesn't recognize Excel.Application causes this error message:
    * Error Type:
      Server object, ASP 0178 (0x80070005)
      The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
      /testexcel.asp, line 22

Any Help?

Why are you trying to create an ADO connection to the Excel workbook?? The reason, in your first example, that the Jet Driver doesn't recoginize .Run is because .Run isn't part of an ADO object.

What you should be doing is something like this:

Dim xls
Set xls = CreateObject("Excel.Application")
xls.Workbooks.Open [Path to excel file], 3, False
xls.Run("[workbook].[macro]")
set xls = Nothing

"The one language all programmers understand is profanity."

with the code above I get this message.

Error Type:
Microsoft VBScript runtime (0x800A0046)
Permission denied: 'CreateObject'

Can someone tell me why its denying me permission to createobject? The excel isn't read-only and I am the admin.

Try Server.CreateObject though that shouldnt make a difference. What you may want to look at is the premissions of the folder the excel file resides in.

"The one language all programmers understand is profanity."

With that I've got:

The call to Server.CreateObject failed while checking permissions. Access is denied to this object.

I've also tried New server.createobject, New createobject with no success.
But createobject(ADODB.connection) and createobject(ADODB.recordset) works. So my createobject is fine its just that its preventing me access to Excel.Application for some reason.

Read these:

http://www.aspemporium.com/support.aspx?PRB020

Related to Word but should be helpful:

http://p2p.wrox.com/archive/beginnin...2002-12/51.asp

"The one language all programmers understand is profanity."