Milton,

You can record a macro in your Personal.xls while you do the formatting.
Than the next time you can just run the macro.

--
sb
"milton" wrote in message
...
I don't know if was clear enough on my posting. I have an existing txt
file which I use for direct deposit that my software generates, but I have
to take that existing file and format it to look like the Standard 5
Format.
I manually created the Std 5 file, but I was hoping that someone could
help
me build the macro, or guide me in the right direction on writing the
macro(script) in order for the bank to process it in the Std 5 format. My
manual version works, according to the bank, but I don't want to format
the text file manually every time.

Please help.

Milton