DJ Peterson
New Member
- Joined
- Jan 23, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet that is processed in a VBA program that takes the data line-by-line and after validation, uploads it to a server. I'm using ActiveX Data Objects 2.8 to upload to the server. It seems that either ADO or the server does not like any 'Inserted characters'. I need to search each cell to see if there is any symbol in the string that was placed there by using 'Insert Symbol' in Excel. If found, then I will replace the symbol with text representing that symbol (character). For Instance I need to find any occurance of the Omega symbol 'Ω' and replace it with Ohm. I can't figure out how to use InStr() or Replace() to find it. The Omega symbol is a hex 2126 or decimal 8486. I've tried chr(8486) and chrW(8486) but none of these work. An example of the string data in a cell is 'R1 10kΩ, R2 10kΩ, 50V, NPN+NPN'.
Any one have any ideas?
Thanks
Any one have any ideas?
Thanks