Hello,

I have an Excel application which I need to export to a TXT file for
import into another system. The column lengths are fixed i.e. Column
A = 10, Column B = 30. In total there are 800 characters per row.

I wanted to use VBA to export the file by clicking a button using the
FileFormat:=xlTextPrinter option. Using FileFormat:=xlTextPrinter
does not export the file correctly I think it only outputs the first
256 Characters.

Can anyone help / offer any advice?

Thanks,

Brett