Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Alt Tab from wkbk to wkbk Help! Paulg Excel Discussion (Misc queries) 1 August 15th 06 05:34 PM
VBIDE.VBComponent michaelberrier Excel Discussion (Misc queries) 3 June 12th 06 05:47 PM
looking for way to name columns (across sheets in wkbk) mr unreliable New Users to Excel 3 February 10th 05 09:32 PM
VBProject events? Chip Pearson Excel Programming 0 September 10th 03 10:36 AM
load userform from other VBProject (Excel 2000) Keith Willshaw Excel Programming 1 July 28th 03 04:12 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"