Help Creating a Macro

M

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
 
M

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
 
M

milton

milton said:
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
Click to expand...
 
Top