Windows Compatible Folder Name

Hi

You could either remove incompatibel characters first, or you could switch error reporting off and then check whether an error occurred during running of the MkDir and if so, warn the user that the folder name was invalid (I probably prefer this approach):

Please Login or Register  to view this content.

Richard

I would have thought that if the folder name was incompatible with the file system then it couldn't be created in the first place!

You could use a function to strip any non-alphanumeric characters out fo the folder name before you create it. Such a function could be:

Please Login or Register  to view this content.

The above will get rid of any characters except for underscores and alphanumerics (it will remove spaces too).

Use in your sub like:

Please Login or Register  to view this content.

Richard

Double spaces and double comma don't prevent me from applying to the name of or subsequently using the new folder. Good luck with your search.

Using Richard's idea, all you need is a loop that will replace any illegal characters with NULL or some other character you choose:

Please Login or Register  to view this content.

Where:
fnamestr - is the folder/file name built up from the various cells, and
illegalcharset - is an array of illegal characters such as "<>,?|\*;: