![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Does anyone know why the error "Cannot create object" would occur when trying to create an Excel object in VBScript within a DTS ActiveX? |
#3
| |||
| |||
|
|
-----Original Message----- Remember DTS is client side so it may be that you are creating it on a computer without Excel. -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Robert" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:29a401c4c051$199c8ab0$a601280a (AT) phx (DOT) gbl... Does anyone know why the error "Cannot create object" would occur when trying to create an Excel object in VBScript within a DTS ActiveX? . |
#4
| |||
| |||
|
|
That is the case. Do you know if it is possible to load just the Excel library without installing the Excel application? -----Original Message----- Remember DTS is client side so it may be that you are creating it on a computer without Excel. -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Robert" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:29a401c4c051$199c8ab0$a601280a (AT) phx (DOT) gbl... Does anyone know why the error "Cannot create object" would occur when trying to create an Excel object in VBScript within a DTS ActiveX? . |
![]() |
| Thread Tools | |
| Display Modes | |
| |