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

Hi Michael

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Michael Vaughan" wrote in message ...
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 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



Michael Vaughan wrote:

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

--

Dave Peterson

Thanks Ron and Dave!

I will give it a shot.

Thanks agian,

Michael


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