VBA Using FileFormat:=xlText

[brettmanning24]

Hello,

I am using VBA to output some data from Excel in TXT format. The TXT
format is then imported into another application. The application
does not look for "," when import but the length of the field. I have
therefore made sure the cells in Excel are the correct length. For
example:

Cell A = 5 Characters
Cell B = 10 Zero's
Cell C = 5 Spaces
Cell D = Date in format YYMMDD

So the output file should look like this:

DDDDD0000000000 080326.

When the file is exported from Excel it looks like this

DDDDD 0000000000 080326.

Can anyone help, I do not want a gap between the cells. Is it because
I am using xlText?

Thanks,

Brett