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
Last edited by HarryKlein; 01-13-2012 at 11:46 AM.
Use below function in your macro to remove /.Same you can repeat for all un wanted charecters.
mystring = Replace(mystring , "/", "")
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.
I have given for three charecters /, ? , |.You can extend further.
mystring = Replace(Replace(Replace("mystring", "/", ""), "?", ""), "|", "")
Thanks a lot.
That helped a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks