DOS Equivalent File Nomenclature

Can someone tell me if the second line is the DOS equivalent of the first line?

HTML Code: 

HTML Code: 

In a command window, use "dir /x" without the quotes.

If you start in Documents and Settings/user name, you'll see MYDOCU~1 for My Documents.

Go down a level into My Documents to see what the files in the folder are called. Not sure you can guarantee it because it will depend on how many similar file names there are.

Regards

Kenneth,

WOW!! what a program... and you graciouisly added my personal directory tree.

I ran the program and the DOS equivalent to "My Documents" is "Docume~1".
Does this seem right to you? or should it be "MyDocu~1"?

Steve

PS I will run a trial tomorrow to validate the program output.
Thanks so much for your efforts

or

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

snb,

There seems to be no limit to your knowledge of vba... brilliant

I have copied your code below with some remarks added so that I can understand the purpose and output of the code.

This piece of work also confirms Mr. Hobson's quality coding effort that any name we give to the documents directory is system-read as "documents". Any other folder name is treated as a proxy name.

Please Login or Register  to view this content.

From another library you can use the default documentdirectory ( in your case :"C:\users\steve\Documents\") using:

CreateObject("wscript.shell").specialfolders(13)

Please Login or Register  to view this content.