#1
|
|||
|
|||
Operator symbols are not recognized by vba
Hi All,
We are using a script for converting the special characters to entity including operator symbols, but some case operator symbols converted to "?" instead of respective entity. We are manually recognized the character using ?(selection.text) in immediate window, it will generate "?". Also we are checking missing font list and substitute same font list in library. Still problem persist. Please advice. Thanks in Advance Sankar B |
#2
|
||||
|
||||
To which operator characters do you refer?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi Paul Edstein,
Thanks for your response. operator characters: minus, plus and times. Thanks Sankar B |
#4
|
||||
|
||||
Are you sure you are using ASCII:
• 42 for the * • 43 for the + • 45 for the - • 47 for the / You cannot use non-ASCII characters, even if they look the same in other programs or in a Word document.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Operator symbols are not recognized by vba
Hi Paul Edstein,
Yes, I understood, but my problem is not recognize the character by VBA script. Kindly refer the screen shot from the attachment. Thanks Sankar B |
#6
|
||||
|
||||
There is no attachment...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Hi Paul Edstein,
Sorry, find the attachment. Thanks Sankar B |
#8
|
||||
|
||||
There is still no attachment...
To attach a document to a post, use the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Kindly find now.
Thanks, Sankar B |
#10
|
||||
|
||||
That looks to me like a character in another font or, perhaps, a non-ASCII character in the same font. What do you get if you select the character and run the following macro:
Code:
Sub GetChar() Dim SelFont, SelCharNum With Selection With Dialogs(wdDialogInsertSymbol) SelFont = .Font SelCharNum = .CharNum End With End With MsgBox SelFont & vbTab & SelCharNum End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#11
|
|||
|
|||
Hi Paul Edstein,
Please find the attachment, It has what am getting when select a char and run the script. Thanks Sankar B |
#12
|
||||
|
||||
What the message box confirms is that you do not have the letter 'x' there, but the '´' symbol from the symbol font. As such it's a protected character, for which you can't obtain the equivalent ASCII value (hint: 4096-3916) in the immediate window. If you change the font to, say, Arial or Times, you'll be able to read the ASCII value. Whether that's any use to you depends on what you're trying to do.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#13
|
|||
|
|||
Hi Paul Edstein,
Thank you so much. Sorry for the late review and your solutions is very helpful me. Thanks Sankar B |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is it the PC, the monitor, or the operator? | CarlT | Windows | 1 | 07-11-2014 06:09 AM |
When Outlook starts, a warning box "String was not recognized as a valide datetime" | twormington | Outlook | 4 | 02-03-2014 11:01 PM |
Mail Merge using Word 2010 - Header source not be recognized | Gage262 | Word | 8 | 02-01-2012 11:08 AM |
Contacts Not Recognized | WinoWally | Outlook | 1 | 09-28-2010 02:58 PM |
.rtf being recognized as picture | amerifax | Word | 3 | 10-06-2009 09:23 AM |