CreateObject("Excel.Application") fails after upgrading Excel on server from 97 to 2003
Posted on 2008-10-28
This server side VB script
Set objExcel = CreateObject("Excel.Application") ' Create an Excel object.
objExcel.Application.Visible = true
objExcel.Application.UserControl = true
fails with error
ActiveX component can't create object: 'Excel.Application'
after upgrading Office from 97 to 2003 on the server.
App is opening Excel on server, generating file, saving it, and then emailing it to user. After reading it appears it could be a permission issue for the account generating the excel process????