I have a middle tier object that generates Excel spreadsheet
here is the code
moExcel = CreateObject("E xcel.Applicatio n")
moWorkBook = moExcel.Workboo ks.Add
moSheet = moWorkBook.Work sheets(liSheetN um)
moSheet.Delete( )
moSheet = moWorkBook.Work sheets(liSheetN um)
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!