VBScript......CreateObject("Excel.Application") is failing when run in web page.
Posted on 2004-04-08
I wrote a vbscript that I need to run (client side) everytime someone visits an intranet page. Basically the vbs creates an excel.application object writes some data to the spreadsheet and then saves it. I created a test html page and inserted the vbscript and it works fine when I run it from my pc. But if I try to run it from a server, or even another computer it fails when it tries to create the excel.application object. It says the activeX object couldn't be created. Why? Can someone help please?? Here is some test vbs code I inserted into a test page, it fails when I run it from anywhere but my pc.
Set objExcel = createobject("Excel.application") <----------- This is where it's failing
objexcel.Visible = True
objexcel.Cells(1, 1).Value = "Testing"