Writing Batch File

[Michael Vaughan]

Hello Everyone,

Is there a way I can write in my VBA code a batch file command and then save
it as .bat file??

I would like to enter:

"C:\Program Files\InternetMacros\imacros.exe" -macro CalendarInsert -loop 19
echo Batch file completed

Then I would like to save it as: sample.bat

Thanks.. Michael Vaughan

 

[Ron de Bruin]

Hi Michael

See how I do it here
http://www.rondebruin.nl/csv.htm

 

[Dave Peterson]

Ron de Bruin shows how to create a .bat file to merge .CSV files.

You could modify his code to do what you want:

http://www.rondebruin.nl/csv.htm