find & replace bullets & numbers 1

[hofburg]

Hi,
I have documents featuring numbers and bullets. Sometimes it is necessary to get rid of them, as they confuse another application. To do this via macro is no problem.

Now I'd like to keep my document structured and would not like just to get rid of them, but to replace them with, say, *s (or plain numbers) so I`d need vba code finding and replacing them by an ASCII character.

Is this possible?

Many thks,

UJ

 

[fumei]

I was thinking this would be an easy one. I am getting some rather odd behaviour. Working on it.

However, I have questions.

Why are you doing this? Bullets and numbers are, from a reader point of view, form a much more visible structure than an apparent random charcter...like "s". I do not understand why you want to replace bullets / numbers with an "s".

Gerry
See my Paintings and Sculpture

 

[TonyJollans]

Hi hofburg,

I, too, have a question!

Bullets and Numbers are not part of the text of a document, they are part of the formatting. Just what is this other application and what exactly is it doing to get confused in this way?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[hofburg]

Hi,
bullets do make sense but sometimes our texts are processed by a third party software that does not support them.
The idea is to run a macro that finds bullets & numbers and replaces them with, say, a "*" (not "s", sorry), in order to keep the text as structured as possible.

Thks,

ZH

 

[fumei]

Structured as possible? So now you have a bunch of paragraphs with * at the beginning of them? Hardly seems a particularly useful "structure". Of what use is this, as structure?

OK, I can understand a third party software that does not understand Word format, and may need, say, RTF at the most. But, not support bullets? Sounds lame.

Oh well. Could you answer Tony's question. What is this software, and exactly is it doing?



Gerry
See my Paintings and Sculpture

 

[PHV]

Just a though, why not using the SaveAs method to produce a .TXT file for the third party software ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hofburg]

Thanks PHV,

that is perfect, saving file as .txt does exactly that. The solution is sometimes simpler then you think it could be.