Macro to run Bat file from Excel

[graiggoriz]

Hello,

I am copying cells from excel to notepad and rename the extension to *.bat.

I fact it regards commands thaht I need to generate and I was wondering if I could create a macro to generate all the bat file directely from Excel...

It seems really hard to do but I give a try in that forum as I got some great help in the past.

So the idea would be to copy each cell (windows command) I have in the cells (G2,G3,G4,G5,G6,G7,G8,G9,G10,G11,G12) have create a bat file for each.

Example: I have in the G2 cell: C:\dir
--> I would need to copy that cell into a notepad and rename the extension as *.bat.. at least that's what I am doing manually for the moment.

If you need further info, please let me know.
Many thanks,
Graig

[hulpeloos]

give this a go , it will go trough G2 till G12 and create 10 bat files with the name in those cells
each bat file will also contain the text that is in the cell that was used to name the file

Please Login or Register  to view this content.