Thread: Line of Code to set references
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Myles[_63_] Myles[_63_] is offline
external usenet poster
  
Posts: 1
Default Line of Code to set references

Chip,

I am a bit at sea here. I need the line of code to set the reference
to "Microsoft Visual Basic for Applications Extensibility 5.3"
programmatically and with the same effect as the manual approach ie the
requisite checkbox in the Reference dialogbox becomes ticked.
*Set x = Application.VBE.ActiveVBProject.References("VBIDE" )* fails to
achieve that.

Myles.


--
Myles
------------------------------------------------------------------------
Myles's Profile: http://www.excelforum.com/member.php...o&userid=28746
View this thread: http://www.excelforum.com/showthread...hreadid=529064

Reply With QuoteReply With Quote