Check the following API call,
http://www.mvps.org/access/api/api0020.htm
regards
KM
-----Original Message-----
I am having a problem getting consistent results from the:
"Application.Path", Activeworkbook.Fullname and
Activeworkbook.Path
commands.
Sometimes I get the full path text as in
"C:\Documents and Settings\weavtennis\My Documents\PM
Sheets\"
but at others all I get is MS DOS/WinNT shortened path of
"C:\Docume~1\ weavte~1\MyDocu~1\PMShee~1\".
Is there a way to consistently get the full path text
version?
System = MS Office '97 version of Excel on a WinXP/NTFS
drive
Or
System = MS Office 2K version of Excel on a Win2K/NTFS
drive
Thanks
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step
guide to creating financial statements
.