ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Batch Files (https://www.excelbanter.com/excel-programming/278771-batch-files.html)

Mitch[_2_]

Batch Files
 
Hello,

How do I create batch files using excel?

thanks

Phobos

Batch Files
 
As in MS DOS Batch files?

You don't, you use a text editor.

You can RUN batch-files from Excel using the Shell command.

P


"Mitch" wrote in message
...
Hello,

How do I create batch files using excel?

thanks




Phobos

Batch Files
 
Actually, you can create batch-files using excel but you would need to
create a text file (see the OPEN command in VBA) write data to the file and
then close it.

Not the easiest way to create batch files...

What are you trying to do exactly?

P


"Phobos" wrote in message
...
As in MS DOS Batch files?

You don't, you use a text editor.

You can RUN batch-files from Excel using the Shell command.

P


"Mitch" wrote in message
...
Hello,

How do I create batch files using excel?

thanks






Mitch[_2_]

Batch Files
 
Hello,

Is it not possile to use excel to create the text file
then run it?

Thanks
-----Original Message-----
As in MS DOS Batch files?

You don't, you use a text editor.

You can RUN batch-files from Excel using the Shell

command.

P


"Mitch" wrote in message
...
Hello,

How do I create batch files using excel?

thanks



.


Mitch[_2_]

Batch Files
 
Hello,

Have a tool to send "Net Send" messages, currently this
loop's through lengthy lists of PC addresses that are on
the network.

There are several different list's depending on which
user group the message needs to go to. This is causing
numerous CMD boxes to appear in the task bar while it
runs.

I was hoping to create a batch file to send the message,
thereby reducing the number of boxes that appear.

Thanks
-----Original Message-----
Actually, you can create batch-files using excel but you

would need to
create a text file (see the OPEN command in VBA) write

data to the file and
then close it.

Not the easiest way to create batch files...

What are you trying to do exactly?

P


"Phobos" wrote in message
...
As in MS DOS Batch files?

You don't, you use a text editor.

You can RUN batch-files from Excel using the Shell

command.

P


"Mitch" wrote in message
...
Hello,

How do I create batch files using excel?

thanks





.



All times are GMT +1. The time now is 02:36 PM.

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