Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / April 2006

Tip: Looking for answers? Try searching our database.

VB Reference Libraries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FBxiii - 03 Apr 2006 14:26 GMT
Hi,

I need to activate certain VB reference libraries within a VB6 project using
code (e.g. Microsoft Office 11.0 Object Library).

This will ensure all users applications have reference to the correct
Reference library!!!

Can anyone help?

Cheers,
Steve.
Douglas J Steele - 03 Apr 2006 17:28 GMT
You'd be better off asking in a newsgroup related to VB than one related to
Access, then.

Do you know for a fact that all your users will have Office 2003 installed?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
>
[quoted text clipped - 8 lines]
> Cheers,
> Steve.
Robert Morley - 04 Apr 2006 16:09 GMT
I think what he's getting at is that he wants to activate the references
based on whatever the current version of Office is, which as far as I know,
you can't do.

The only solution in this case would be to use late binding.  (i.e., Dim
myVar as Object)

Rob

> You'd be better off asking in a newsgroup related to VB than one related
> to
[quoted text clipped - 16 lines]
>> Cheers,
>> Steve.
Douglas J Steele - 04 Apr 2006 17:02 GMT
On rereading the post, you're probably correct about the question. If so,
you're definitely right that late binding would be the only solution.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I think what he's getting at is that he wants to activate the references
> based on whatever the current version of Office is, which as far as I know,
[quoted text clipped - 25 lines]
> >> Cheers,
> >> Steve.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.