In the VBA Immediate window, type the following and press Enter

?ThisWorkbook.VBProject.References(3).FullPath

Change the 3 to the appropriate reference number.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"big t" wrote in message
...
hi everyone,

hopefully this is a quick one...

i have a missing reference in my VBA but when i look at Tools...References
the full path to the missing file is too long to see in the Location: bit.

any ideas as to how i can find the full path for the missing reference?

TIA
big t