Macro for automating the manual stuff

**shruthidwh** · 09-30-2011, 10:01 AM

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

**shruthidwh** · 09-30-2011, 10:58 AM

Hi ,

If any one has any example of a some macro..,where we will get the data from the xls and generate the files.,pls provide me I will start with that as I am new I don't know where to start this from.

Regards,
Shruthi

**Nithya1987** · 09-30-2011, 12:01 PM

Hey , Macro will be complicated for your requirement, I think you should keep your existing code as is, you may convert the xls to csv and using some batch you can copy the column E to separate batch scripts.

Writing the entire code as per your requirement will be very complicated.

**jaslake** · 09-30-2011, 04:19 PM

Hi shruthidwh

This code is in the attached. It creates the output in Column E. You'll need to verify the spacing is correct.

Please Login or Register  to view this content.

Included in the code are two procedures for creating the .BAT file. I'm certainly no expert in creating .BAT files (or much of anything else for that matter). The .BAT file code is from http://visualbasic.ittoolbox.com/gro...celvba-3926212 and has been modified to suit. You can try either procedure by uncommenting one and commenting the other.

Let me know of issues.

PS: By the way...Welcome to the Forum!!!

**shruthidwh** · 10-04-2011, 08:37 AM

Hi John,

Thanks a lot for the macro ., can you please tell me how to modify the below.

if the jobcode in the xls is equal to UR88 then I need to generate some additional parameters(pls see the attachment). Please tell me is there any case statement in vb to acheive this.

Regards,
Shruthi