View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Select reference via code

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.