Help!

I'm struggling with forming an interface with a device I have.

Basically I start out with an excel file that is 7 columns by 48 rows. This sheet is saved as a text file and the device opens up the text file and reads off it to carry out its task.

The excel file needs to be somehow padded at the end of each row(on the right side) to be formatted correctly with the device. The directions that came with the device state to pad it with a space on the last column, but if I do that, then there is a dot between the last tab(the text file is dab delimited) and the carriage return. Anyone know how I can pad the end of each row so there is still a tab between the last cell and the carriage return.

I've tried writing a macro that writes a tab delimited txt file including all the cells with appropriate carriage returns. This does not work as it still needs to be padded at the end of each row somehow.

Thanks for any help.