Object Server error 'ASP 0196 : 80040154'

[forostec]

Hello, i'm having this error:

Object Server error 'ASP 0196 : 80040154'

when i'm trying to run this code:

'// Create excel application object
Set objApp = CreateObject("Excel.Application")

'// Open the workbook (.xls) file
Set objBook = objApp.Workbooks.Open("c:\mis documentos\prueba.xls")

'// Select the sheet
Set objSheet = objBook.Sheets.Item(0)

'// Set a celltext
objSheet.Range("A1").Value = "This text is set from ASP"

'// Close the workbook and save changes
objBook.Close True

'// Exit excel (important! especially when running on server!!!)
objApp.Quit

'// Garbage collection (just to make sure)
Set objSheet = Nothing
Set objBook = Nothing
Set objApp = Nothing

I noticed that i have the problem with IIS 4.0 in windows NT where i need to setup the AspAllowOutOfProcComponents but i don't how to do this with the Microsoft Management Console MMC.

How can i do this? I'll been searching but i don't know, Please help. :-(

 

[DreXor]

i dont tinker with excel.applications much, i tend to just port straight to CSV and make excel open it

Links :
almost a mirror of what you're trying to do with more documentation ( i found the example you got that code from, very vague

http://www.4guysfromrolla.com/webtech/051502-1.shtml

old stuff, but this link might help too (how to formula etc)

http://www.15seconds.com/issue/970515.htm

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!