My Documents

[Guest]

Is there a way in VBA to determine what the actual path name is for a
shortcut path such as [My Documents]?

The actual path is usually
C:\Documents and Settings\[MACHINE NAME]\My Documents

I need to be able to add an entry into a listbox of directories that says
[My Documents] and figure out via VBA what the actual path for that is.

Thanks in advance for your help!

 

[Guest]

Hi Peter,

Check out this API:
Retrieving a Special Folder's location
http://www.mvps.org/access/api/api0054.htm

In the list of constants, you should see this:
' File system directory that serves as a common repository for documents.
' A typical path is C:\Documents and Settings\username\My Documents.
Public Const CSIDL_PERSONAL = &H5


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Is there a way in VBA to determine what the actual path name is for a
shortcut path such as [My Documents]?

The actual path is usually
C:\Documents and Settings\[MACHINE NAME]\My Documents

I need to be able to add an entry into a listbox of directories that says
[My Documents] and figure out via VBA what the actual path for that is.

Thanks in advance for your help!

 

[Guest]

thank you!

 

[Guest]

Hi Peter,

You're welcome. Glad I could help.
Thank You for marking my reply as an answer.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

thank you!