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 |
All times are GMT +1. The time now is 09:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com