Selection.Replace What and double quotes

[Ed Peters]

Hi all,

I need to replace double quotes " with nothing.

However the code below does not work for double quotes.

Selection.Replace What:=""", Replacement:=""

Any ideas?

Thanks,

Ed

 

[Rick Rothstein \(MVP - VB\)]

Change your What value to this...

What:=""""

There are 4 quote marks after the equal sign.

Rick

 

[Ed Peters]

Change your What value to this...

What:=""""

There are 4 quote marks after the equal sign.

Rick










- Show quoted text -

Thanks but that does not work. I can replace any other character but
not "...
Ed

 

[Joel]

When I have problems with double quotes there is always one method that works

What:= chr(34) ' one quote
or
What:= chr(34) & chr(34) 'two quotes
or
What:= chr(34) & chr(34) & chr(34) 'three quotes

 

[Rick Rothstein \(MVP - VB\)]

I need to replace double quotes " with nothing.

Thanks but that does not work. I can replace any other character but
not "...

Did your line look like this...

Selection.Replace What:="""", Replacement:=""

....four quotes for the What and two quotes for the Replacement? When I tried
that line, it worked on my system.

Rick

 

[Ed Peters]

Did your line look like this...

Selection.Replace What:="""", Replacement:=""

...four quotes for the What and two quotes for the Replacement? When I tried
that line, it worked on my system.

Rick- Hide quoted text -

- Show quoted text -

Thanks sorted it now, I need all the other default options included in
the selection.replace for it to work.

Ta

Ed