View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anson[_2_] Anson[_2_] is offline
external usenet poster
 
Posts: 28
Default GUID of the Reference

I am trying to write a macro to add a VB Project reference. By using

NewWorkbook.VBProject.References.AddfromGuid("Guid ","Major","Minor")

Now how can I find the the GUID, major and minor of the reference that I trying to add? By the way, I am trying to add "Microsoft Visual Basic for Applications Extensibility" and my version is Excel 97.

Thanks,