Macro or Script???
 

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

Macro or Script???
 

Milton,

You need to provide more detail for someone to help you.

What are starting with? And what do you want to end up with?

Knowing that, you can get some guidance.

What you might want to do is, complete the "transition" from your starting
position to your final position using the Macro recorder. And then we can
probably help you "tune" the recorded macro.

But without knowing what you are trying to accomplish, we are unable to
assist as we cannot look over your shoulder. Thus, you need to be very
explicit.

Regards,
Kevin


"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

Macro or Script???
 

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