Help Creating a Macro

[milton]

Hi does anyone know of a program that might help take an exsiting txt file
and format it to like a revised version of that same file. I figure it would
be easiest to format it via a macro in excel, but I am not quite versed
enough in macro building to get it to formatt properly.

Any sort of help would be appreciated.

Thanks

Milton

 

[Guest]

check the post above by Gerry R
I think you are talking about the saem thing.

Thanks,
-Neil
(e-mail address removed)

 

[milton]

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

 

[milton]

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