Solved: Latest Versions Of Available References...

[Wolfgang]

Hi All...

Is is possible to activate the latest references in Excel's VBA-list according to the user's Office version?!

Say that I set a reference to the Microsoft ActiveX Data Objects 2.8 Library using Office 2003 pro sp2...

Now, some of the users will have Office 10 or less, how can I make sure that they automatically activate their latest references without having them to switch to the VBA environment and mess it all up?!

Thank you very much...

Best,
Wolfgang

[Norie]

Wolfgang

Why do you need the references?

If it's for code then you should probably take a look at late-binding, which will eliminate the need for them in the first place.

[Wolfgang]

Hi Norie...

Thank you very much for your advise and yes it is for code...

BUT, coding is not my outspoken strength and so far I haven't touched early/late binding in any way...

Best,
Wolfgang

[Bob Phillips]

Hi Norie...

Thank you very much for your advise and yes it is for code...

BUT, coding is not my outspoken strength and so far I haven't touched early/late binding in any way...

Best,
Wolfgang
If you are using referenced libraries, you are using early binding.

See http://xldynamic.com/source/xld.EarlyLate.html for some help.

[Norie]

Wolfgang

Check out that link from xld, it looks pretty good.

If you need any further help then post your code.

[Wolfgang]

Gentlemen,

Thank you for your replies...

I will take a look at Bob's link tomorrow because it is 08 PM already and this stuff needs a fresh mind...

Best,
Wolfgang

[Wolfgang]

Good Morning Bob...

Finally I managed to read through all this vital information that you pointed me at and I found, what I was looking for...

Thank you very much and have a nice day..

Best,
Wolfgang