View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Haberl Joe Haberl is offline
external usenet poster
 
Posts: 1
Default 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