LinkBack URL
About LinkBacks
How can I use "฿" in VBA code
EG:.
Range("Artwork_Anchor") = Mid(Cells((Dte) + 2, 1).Value, InStrRev(Cells((Dte) + 2, 1).Value, "$AUD") + 4)
So instead of $ i want ฿
How can I use "฿" in VBA code
EG:.
Range("Artwork_Anchor") = Mid(Cells((Dte) + 2, 1).Value, InStrRev(Cells((Dte) + 2, 1).Value, "$AUD") + 4)
So instead of $ i want ฿
Hi
The ฿ is the Unicode Character 'THAI CURRENCY SYMBOL BAHT' (U+0E3F)
Ex.:
(Just an example of how to use the character, it would probably make more sense in this case to use a custom format and a number value.)
Please Login or Register to view this content.
Try this code
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Just used the ChrW(&HE3F)in my code. Worked like a charm. Thanks!
I have been able to print the Baht sign using the formula described above (Range("A1").Value = ChrW(&HE3F) & "123". But my problem is different in that I would like to automate the REMOVAL of the Baht sign from spreadsheets sent from Thailand. I need to do this because I own a restaurant there and I get the daily sales and expenses every day but I can't consolidate those worksheets to get weekly, monthly and annual numbers unless I remove it because Excel does not recognize it. I can remove it manually from each individual worksheet by copying the Baht sign from the worksheet and removing it using "Find and Replace" but I would like to automate the technique, if possible, to save myself some time. Unfortunately, the macro doesn't work because the VBA doesn't recognize the character and trying to replace it in the code doesn't work either. (It replaces the Baht sign with a "?" and so the code won't run). I have tried to use the unicode but that doesn't work either. Can someone suggest a method for removing the Baht sign from the spreadsheets with a macro or some VBA code? Is it even possible? I would appreciate any ideas.
Administrative Note:Originally Posted by etpho
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks