File Name and Path Name

[Simon]

Dear reader,

The function:

Dim refCurr as Reference

refCurr.Name

Gives you a name, sometimes the pathname + filename and sometimes the
filename only.

I can't find whey this differences, I am looking for the filename only.

Tanks for any help.

Kind regard,

Simon

[Allen Browne]

References(1).Name should return the abbreviated name for the library,
assuming one is registered. This is the case for these libriares:
- Access
- VBA
- DAO
- ADODB
- ADOX
- Office
but it probably depends on how the library is registered with Windows.

Note that the Name of the library does not match its file name. For example,
the VBA reference is probably VBA6.DLL.

If you want the file name, try:
Dir(References(1).FullPath)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Simon" <Sv********@Versatel.nlwrote in message
news:45*********************@news.tele2.nl...

>
The function:

Dim refCurr as Reference

refCurr.Name

Gives you a name, sometimes the pathname + filename and sometimes the
filename only.

I can't find whey this differences, I am looking for the filename only.