I am using old version of Excel, 97. This may be solved in later version but would like to know if it can be solved in Excel 97. I am making an xls to xml convertor. The first thing I need to do is replace characters with the unicode equivalent so that they can be properly displayed in xml. I am using this code repeatedly in my VBA macro for each character I expect to be a problem
Cells.Replace What:="¢", Replacement:="¢", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
The issue is that I cannot paste certain characters into the What:=" ", because the editor does not recognize them. An example is the square root sign. If I try and paste it from character map is is not a radical sign in the editor.
Any way around this??
Thanks Dan
Cells.Replace What:="¢", Replacement:="¢", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
The issue is that I cannot paste certain characters into the What:=" ", because the editor does not recognize them. An example is the square root sign. If I try and paste it from character map is is not a radical sign in the editor.
Any way around this??
Thanks Dan