BB codes with Excel 365

[DocAElstein]

....., I ran into a problem: Using Hebrew characters would output `?` in the BB Code, Do you have any lead for me as to how to solve this issue?

Hello Voigon,

An interesting question , but I doubt that I can give much more than some general comments on this one… not yet anyway..

I am not fully familiar with the various BB-Code-generating coding which I referred to, as I have only made minor modifications to them. I was not involved in any of the original writings of the coding.
But it does not surprise me that you hit the "???" output type problem.

My guess is that VBA only supports English stuff mostly, for example, such that text strings held are somehow held in terms of strings of English characters. I am not sure of the exact process. But I have often seen , that characters which are not English, are usually held and shown in VBA held strings as ?s

However, I am glad you brought this up, as I do intend finally getting around late this year to writing my own BB Code generating macro, possibly as an Add-In , if I can figure out how to do that. I will certainly consider this aspect. I will make a note to post a follow up here..

As far as I know, there are no coding available that will allow you to get a BB Code which has other language text preserved. I am not even sure yet if it is at all possible.


I have not really thought too much yet about how I would tackle this problem yet.
But I guess my start point will be to remind myself of some of the work I did for this Thread:
http://www.excelfox.com/forum/showth...ts-of-a-string
Then I will google a bit , and read things like this,
https://answers.microsoft.com/en-us/...6-95af5f29e324 ,


My initial approach will probably be then to see if I can record what is in a cell in terms of a breakdown of its characters , ( rather than the simple cell.Value type approach , which takes a complete string into VBA , and most likely results in the "???" held for non English characters. )
I don't know at this stage if this approach will be successful.


So, I am afraid I can not be too much help just now on this one.
I will post again if I get anywhere later on this when writing my own BB Code generator later this year.
Please let us know if you make further progress
Good luck

Alan