Truncation when reading contents of cell

[AVR]

Hello,

When I try to read a few particular cells though VBA and write it into a text file, the string in the text file gets truncated at 255 chars. When I try to display the value I have read from the cell, it still displays a truncated value (more than 255 chars though). Is there a way to read the entire contents of the cell as is, with no truncation ?

Thanks in advance.

[Leith Ross]

Hello Avr,

You should include the code you are using to read and write your data with. The formula bar will display up to 1,000 + characters while the cell truncates to 255. These values are different if you are using Excel 2007.

Sincerely,
Leith Ross

[AVR]

Hello,

I read the data cell by cell and if needed, write it onto another sheet(for another purpose):

Worksheets(newsheet).Cells(currRow, currCol).Value = Worksheets(oldSheet).Cells(i, j).Value

I then save the entire sheet as a text file using:

Application.ActiveSheet.SaveAs Filename:=fname, FileFormat:=xlTextWindows.

How can I specify that the contents of cells must be extracted completely always ?

Thanks

[AVR]

Looks like I am able to extract the contents correctly. However, when I save the sheet as a .txt file, the data gets truncated.
Should I try some other way to save the sheet as a txt file, instead of using the macro I recorded ?

[Leith Ross]

Hello Avr,

I have been looking up information on xlTextWindows and haven't found much. Not sure why you chose this file format, but I would save the worksheet as xlCSV.

Sincerely,
Leith Ross

[AVR]

Thank you for the inputs. I had tried xlCSV too earlier. The trouble is still that the contents of the cell is truncated to 255 chars. An explicit copy paste does take the entire cell content and paste it well but saving the sheet as a file does not work. Is there any other way around this ?
Thanks !