Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with wkbk.VBProject.VBComponent
Hello,
I am trying to remove code Modules from an Excel97 workbook from an Access97 mdb on a win2k workstation. I made the reference to vbeext1.olb (vba Extensibility) so that I could get the vbcomponents in early (or is that late) binding. I have the same setup on a win2k Server computer with Office97 (yeah, I know, I should be on Office2k), and I can remove the code modules from Excel97 workbooks no problem on the server. But on the workstation with the exact same subroutine same workbook, I get the error message that "Class doesn't support Automation" But it works OK from within the Excel VB IDE. Would anyone know what library file (dll, olb) I might be missing on the workstation that I obviously have on the server? Other than this, Office97 works fine on the win2k workstation. I copied the contents from Program Files\Common\Microsoft Share\VBA folder on the server to the workstation. But that did not fix the problem. I am missing another file. Any suggestions appreciated. Thanks, Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Alt Tab from wkbk to wkbk Help! | Excel Discussion (Misc queries) | |||
VBIDE.VBComponent | Excel Discussion (Misc queries) | |||
looking for way to name columns (across sheets in wkbk) | New Users to Excel | |||
VBProject events? | Excel Programming | |||
load userform from other VBProject (Excel 2000) | Excel Programming |