View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_14_] Bob Phillips[_14_] is offline
external usenet poster
 
Posts: 216
Default Tools | References

This will list all set references

Dim ref As Object

For Each ref In ThisWorkbook.VBProject.References
Debug.Print ref.Description
Next ref


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"AA2e72E" wrote in message
...
Can someone tell me:
1. Where in the registry the list to references are held?
2. Whether it is possible to read that list using VBA instead of using
RegRead?

I can read the references that are checked in using VBA; I'd like to be

able
to read all the available references.
Thanks.