Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I pull a text string off a web page, that contains some random text.
From time to time, the string will contain a mixture of ASCII and ISO encoded characters. Sample below. I'm unable to get any function to recognize the string. I'm using VBA 6.0 with Excel 2000 Example code: Subject= "Auction" Subject = Replace(Subject, "B", "A") I've also tried every other character that should be in that string. The replacement never takes place, the string is unmodified. I've also tried searching for just "&#" but it never finds that either. I've tried using InStr as well but that fails to find a match too. The goal is of course to dechiper the (random) string into it's ASCII equivalent (so that it can be read by a human). Any help? Thank you in advance - Dudely |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create dialog box that will post to worksheet encoded data? | Excel Discussion (Misc queries) | |||
Excel docs opening encoded | Excel Discussion (Misc queries) | |||
Opening UTF8-encoded CSV file (Excel 2004 for Mac) | Excel Discussion (Misc queries) | |||
How to open a UTF-8 encoded CSV file in Excel | Excel Discussion (Misc queries) | |||
Importing UTF-8 Encoded CSV Files. Problem | Excel Programming |