I believe I had previously asked this question but cannot find the post.
I'm looking for a VBA solution to replace multiple characters within the same string.
Example:
oWB.SaveAs FileName:="C:\Temp\<=03/31/2010.xls"
The "<, = and /" characters would be replaced with "" ie nothing.
Regards,
John
Multiple Character Replacement
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Multiple Character Replacement
Regards,
John
John
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: Multiple Character Replacement
Regards,
John
John
-
- Administrator
- Posts: 78575
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multiple Character Replacement
Thanks for posting back, I hadn't found it yet.
Best wishes,
Hans
Hans