VBA folder names with a period

[trichmondcpa]

I wrote a little script to create folders based on a cell value. I ran into an issue because I need to create the folders using people's names and there are numerous that have a middle initial and period (that's the way they are formatted in our systems.)

The code below runs fine but what is happening is when it has to save the folder to Smith, Henry A. & Mary B. (the value in the cell) it will drop the final period and name the folder Smith, Henry A. & Mary B (no final period). I would prefer to not have to go in and monkey around with stripping the periods, etc. if there is a convenient way to just have it use the full name already in the cell. I can I guess strip all the periods just curious to learn if there was a better way.

(I erroneously posted about this being a file name issue and have reported my post hoping to have it removed. I apologize for this mistake.)

strDir = Sheets("Table1").Cells(x + 1, 1).Value
strPath = "G:\Folder Test\"
MkDir strPath & strDir

 

[rollis13]

These are characters " * : < > ? \ / | you shouldn't use in folder-names and file-names in a Windows system but . isn't allowed in last position because of rules coming from the old DOS since:
.\ refers to the current directory
..\ refers to the parent directory

So whenever you have something to do with a name with an ending dot you will have to strip it in your table or in the macro:

strDir = Sheets("Table1").Cells(x + 1, 1).Value
If Right(strDir, 1) = "." Then strDir = Left(strDir, Len(strDir) - 1) '<- added
strPath = "G:\Folder Test\"
MkDir strPath & strDir

There is no better way (only a different way to strip the dot).

 

[Marc L]

A way 'to strip the dot' is to use another dot you can find within the ascii characters table …​