Is it possible to select a reference via code? Specifically, I'd like to
select "Microsoft Visual Basic for Applications Extensibility.

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

http://support.microsoft.com/default...b;en-us;213529
XL2000: How to Programmatically Create a Reference

--
regards,
Tom Ogilvy


"Harley" wrote:

Is it possible to select a reference via code? Specifically, I'd like to
select "Microsoft Visual Basic for Applications Extensibility.

Try something like

Sub AddVbIdeRef()
ThisWorkbook.VBProject.References.AddFromGuid _
GUID:="{0002E157-0000-0000-C000-000000000046}", _
major:=0, minor:=0

End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Harley" wrote in message
...
Is it possible to select a reference via code? Specifically, I'd like to
select "Microsoft Visual Basic for Applications Extensibility.