Macro for automating the manual stuff

Hi,

This is my first post in the forum.

I am new to vba programming need your guidance for automating the manual work.

I have a excel based on the data starting from 7th row I am generating a script for a third party tool(DollarU) in column E using concatenation function in xls. This data i am copying to a .bat file and executing it.

I required your help in automating the same using a macro. The macro has to generate the data in column E(pls see the attached file) using macro and the output data should be a .bat file in C:\ folder.

Please guide me how to write a macro for achieving this.

Thanks.

Shruthi