http://support.microsoft.com/kb/160647/en-us
XL97: How to Programmatically Create a Reference

set a reference manually and then query it for the file

? thisworkbook.VBProject.References("vbide").FULLPATH
C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\VBA\VBEEXT1.OLB

FOR EXAMPLE

or try the GUID

? thisworkbook.VBProject.References("vbide").Guid
{0002E157-0000-0000-C000-000000000046}
possibly.

This was from Excel 97, so try it in your version.

--
regards,
Tom Ogilvy



"Myles" <Myles.25o4im_1144033802.5836@excelforum-nospam.com> wrote in
message news:Myles.25o4im_1144033802.5836@excelforum-nospam.com...
>
> Suppose I wish to set reference to "Micosoft Visual Basic for
> Extensibility5.0". How do I accomplish this programmatically?
>
> TIA
>
> Myles
>
>
> --
> Myles
> ------------------------------------------------------------------------
> Myles's Profile:
http://www.excelforum.com/member.php...o&userid=28746
> View this thread: http://www.excelforum.com/showthread...hreadid=529064
>