Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to read DBCS from a cell in VBA
Hello all.
I have a spreadsheet that has DBCS characters in it. When I attempt to write these values to a file, the look like question marks (???????). In stepping through the code, I observe that the data read from the cell is not the DBCS chars, but the ?????. I am reading the value from the cell by this statement: Code: entryXlate = Worksheets(worksheetName).Cells(1, 2).Value where entryXlate is defined as a String. I have a small sample .XLS file which generates the condition if you want to observe for yourself. Any help is greatly appreciated!!! Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
read only cell | Excel Worksheet Functions | |||
I need the cell to read 0 | Excel Discussion (Misc queries) | |||
CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL | Excel Discussion (Misc queries) | |||
How do I read cell value and compare it with other cell in a colum | Excel Programming | |||
read from 1 cell read to and other using vba | Excel Programming |