well this problem of mine is linked to my previous question:
the code that i posted at the end of the above link worked perfectly until last week. then my PC crashed (cursed worm...it's still in here!). i erased and re-formatted my harddrive, and re-installed my IIS (using windows XP pro), and on running the script from the link above i got this error:
Microsoft Office Excel (0x800A03EC)
'psdss.xls' is read-only. To save a copy, click OK, then give the workbook a new name in the Save As dialog box.
.asp, line 846
where line 846 reads:
NB: the excel file it's reading is a shared workbook, it has an ODBC link....and it was working before my pc crashed.
then i migrated my scripts the the server in my lab, the exact same script, not a hair moved...and i got this error:
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object: 'EXCEL.APPLICATION'
asp, line 52
where line 52 reads:
set objExcel = CreateObject (" 'EXCEL.APPLICATION'")
now i need suggestions, or tell me where i'm going wrong...dont have the time to build another system, just need to know how i can correct these faults...asap....im presenting my system this friday!!!!!!!