P
Patrick
I have a middle tier object that generates Excel spreadsheet
here is the code
moExcel = CreateObject("Excel.Application")
moWorkBook = moExcel.Workbooks.Add
moSheet = moWorkBook.Worksheets(liSheetNum)
moSheet.Delete()
moSheet = moWorkBook.Worksheets(liSheetNum)
moSheet.Delete()
We can this middle tier object from the web application, it runs fine
on my development box, but it gave me "Cannot create ActiveX
component." error when I depoly it to the server.
I wrote a simple win app that calls the same codes and tried to run
the win exe on the server box, and it gave me no error.
I think this has to do with security since the win exe is running
under the context of my login (admin) but the web application runs
under aspnet_wp account.
Please help!
Thanks!
here is the code
moExcel = CreateObject("Excel.Application")
moWorkBook = moExcel.Workbooks.Add
moSheet = moWorkBook.Worksheets(liSheetNum)
moSheet.Delete()
moSheet = moWorkBook.Worksheets(liSheetNum)
moSheet.Delete()
We can this middle tier object from the web application, it runs fine
on my development box, but it gave me "Cannot create ActiveX
component." error when I depoly it to the server.
I wrote a simple win app that calls the same codes and tried to run
the win exe on the server box, and it gave me no error.
I think this has to do with security since the win exe is running
under the context of my login (admin) but the web application runs
under aspnet_wp account.
Please help!
Thanks!