By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,060 Members | 1,878 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,060 IT Pros & Developers. It's quick & easy.

File Name and Path Name

P: n/a
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
Dec 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Dec 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.