Tools | References

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.

"Bob Phillips" wrote:

>This will list all set references

Thanks, but as I said in the original post, I can already do this.

What I need is to be able to enumerate all the available references, not
just the ones being used. I know this is in the Registry but cannot remember
where!