Multiple Character Replacement

jstevens
GoldLounger
Posts: 2631
Joined: 26 Jan 2010, 16:31
Location: Southern California

Multiple Character Replacement

Post by jstevens »

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
Regards,
John

jstevens
GoldLounger
Posts: 2631
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Multiple Character Replacement

Post by jstevens »

With a little persevrance I found it.

Regards,
John
Regards,
John

User avatar
HansV
Administrator
Posts: 78575
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multiple Character Replacement

Post by HansV »

Thanks for posting back, I hadn't found it yet.
Best wishes,
Hans