ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Writing Batch File (https://www.excelbanter.com/excel-programming/371509-writing-batch-file.html)

Michael Vaughan

Writing Batch File
 
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

Writing Batch File
 

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




Dave Peterson

Writing Batch File
 
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

Michael Vaughan

Writing Batch File
 
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





All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com