arapahoe
asked on
ActiveX component can't create object
I have visual basic program that calls to excel and save if html format a xls file.
When I execute it inside on cgi (with iis) gives the error "Error: 429 ActiveX component can't create object"
when execute the instruction 'Set objExcel = CreateObject("excel.applic ation")' .... but the same procedure works if I execute it
in the environment of development of visual basic.
Why?
This is the code:
Dim objExcel As Excel.Application
Dim objBook As Excel.Workbook
Set objExcel = CreateObject("excel.applic ation")
objExcel.Visible = False
Set objBook = objExcel.Workbooks.Open(Fi txerOrigen )
objBook.SaveAs FileName:=FitxerDesti, FileFormat:=xlHtml, ReadOnlyRecommended:=False , CreateBackup:=False
objBook.Close False
objExcel.Quit
When I execute it inside on cgi (with iis) gives the error "Error: 429 ActiveX component can't create object"
when execute the instruction 'Set objExcel = CreateObject("excel.applic
in the environment of development of visual basic.
Why?
This is the code:
Dim objExcel As Excel.Application
Dim objBook As Excel.Workbook
Set objExcel = CreateObject("excel.applic
objExcel.Visible = False
Set objBook = objExcel.Workbooks.Open(Fi
objBook.SaveAs FileName:=FitxerDesti, FileFormat:=xlHtml, ReadOnlyRecommended:=False
objBook.Close False
objExcel.Quit
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Set objExcel = Server.CreateObject("excel