Here's one that I'm sure will be uber-easy for you real vba-ers.
I'm writing a macro to clean-up HTML in an Excel file. I need to remove the tag <p class="MsoNormal"> and replace it with <p>. Here's the code I have:
Cells.Replace What:="<p class=Chr$(34)MsoNormalChr$(34)>", Replacement:="<p>", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
But, naturally, it's not working. How do I represent the double quotes in the code so the paragraph tag can be removed?
Bookmarks