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

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
.