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
|