creation of directory fails due to invalid characters

[HarryKlein]

Hi,

I have made a macro, which puts files into a directory. The name of the directory comes from a string, but this string sometimes contains ", ' / etc characters, which prevents the directory-creation.
So the question is simple, how could I remove these characters from myString variable?

Thank you

[kvsrinivasamurthy]

Use below function in your macro to remove /.Same you can repeat for all un wanted charecters.

mystring = Replace(mystring , "/", "")

[HarryKlein]

Thanks, however what I want to avoid is the multiple use of replace, I was hoping, that there is a solution, when I can type all the unwanted character only once.

[kvsrinivasamurthy]

I have given for three charecters /, ? , |.You can extend further.

mystring = Replace(Replace(Replace("mystring", "/", ""), "?", ""), "|", "")

[HarryKlein]

Thanks a lot.
That helped a lot