MS Excel "path" and XP/NTFS folder naming
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 |
MS Excel "path" and XP/NTFS folder naming
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 . |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com