run a DOS .bat files under an excel macro
 

Good Morning
I have created a macro where we can pull data from a central
computer. You login to this computer using a dos .bat file with the contents
listed below:

net use v: /d
net use v: \\CRhe_DK1_L1\alr OpconRead /USER:opconread /persistent:no

How can I run this command under an excel macro? Thanks.

run a DOS .bat files under an excel macro
 

have a look at shell in help

"B.M.Spell" wrote in message
...
Good Morning
I have created a macro where we can pull data from a central
computer. You login to this computer using a dos .bat file with the
contents
listed below:

net use v: /d
net use v: \\CRhe_DK1_L1\alr OpconRead /USER:opconread /persistent:no

How can I run this command under an excel macro? Thanks.