Hi
I am just posting the full code , a By - Product from which was the solution to this Thread. This is just as a convenient place to reference this code in future Threads, as it runs from, and is working on, a WORD document.
The basic idea of the code is to get over the problem of a vBulletin Forum Editor “eating” spaces of more than one in text.
The code runs from a WORD document. It assumes you are preparing a Forum Post in a WORD document.
After preparing your text you highlight your text and run the code. The text is copied to the clipboard with spaces replaced with light grey coloured Tidles, ~ . ( They are included in the Text String in BB Code format for light grey Tidles [color=lightgrey]~[/color] )
You then paste into the Forum Editor.
After posting you barely see the Tidles as they are coloured Light grey. ( if you change that light grey to white, you simply see what appears to be spaces. )
More details and other code alternatives are given here:
http://www.excelforum.com/the-water-...a-space-2.html
_...
Here is that code in the next post.
Sub AlanHansClipboardTextGetFindReplace()




Reply With Quote
Bookmarks