Any reason to favor calling a batch file VS running a CMD directly in A97 VBA?

[MLH]

I have a batch file named GetConf.bat.
It contains a line like this:

ipconfig /all >c:\MyAppDir\IP data.txt

I believe I could run the line with something
like ShellWait by Terry Kreft. Any reason I
should run the procedure via a batch file
call as opposed to launching the command
string directly?

[Douglas J. Steele]

No reason that I can think of.

What are you trying to accomplish, by the way? It may be that you can
retrieve whatever you want without having to resort to those contortions.
Take a look at what Randy Birch has at
http://vbnet.mvps.org/code/network/index.html

(ObWarning: Randy's site is aimed at VB programmers, not Access programmers.
There are significant differences between the controls available on forms in
VB vs. those available on forms in Access. Consequently, not all of the
GUI-related code on Randy's site will port into Access)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"MLH" <CR**@NorthStat e.net> wrote in message
news:9c******** *************** *********@4ax.c om...

I have a batch file named GetConf.bat.
It contains a line like this:

ipconfig /all >c:\MyAppDir\IP data.txt

I believe I could run the line with something
like ShellWait by Terry Kreft. Any reason I
should run the procedure via a batch file
call as opposed to launching the command
string directly?

[MLH]

Thanks, Doug. Regarding the Randy Birch site, I thought you might
have been referring to the section on using INI files??? I found
nothing there though. Which part exactly were you talking about?

BTW, I seem to have run into a snag with ShellWait...
Call ShellWait("ipco nfig /all >c:\IPdata.txt" ) DID NOT WORK!!!
ShellWait ("ipconfig /all >c:\IPdata.txt" ) DID NOT WORK!!!
#AND#
Call ShellWait("c:\P rogram Files\TPSCG\Get Conf.bat") WORKED!
ShellWait ("c:\Program Files\TPSCG\Get Conf.bat") WORKED!

I don't understand. The batch file GetConf.bat contains the same CMD
string ipconfig /all >c:\IPdata.tx t but I've tested and the
file "IPdata.txt " is not being created using the syntax in the first
two cases.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxx

On Tue, 13 Dec 2005 10:14:19 -0500, "Douglas J. Steele"
<NOSPAM_djsteel e@NOSPAM_canada .com> wrote:

No reason that I can think of.

What are you trying to accomplish, by the way? It may be that you can
retrieve whatever you want without having to resort to those contortions.
Take a look at what Randy Birch has at
http://vbnet.mvps.org/code/network/index.html

(ObWarning: Randy's site is aimed at VB programmers, not Access programmers.
There are significant differences between the controls available on forms in
VB vs. those available on forms in Access. Consequently, not all of the
GUI-related code on Randy's site will port into Access)

[Saintor]

In some conditions, I prefer to use a batch file.

Like starting a database with a workgroup and switches using the "start"
command. Benefit? You don't need to know the full path of msaccess.exe on
each workstation on a network. application.fol lowhyperlink is an
alternative I use to open PDF files.

"MLH" <CR**@NorthStat e.net> wrote in message
news:9c******** *************** *********@4ax.c om...

I have a batch file named GetConf.bat.
It contains a line like this:

ipconfig /all >c:\MyAppDir\IP data.txt

I believe I could run the line with something
like ShellWait by Terry Kreft. Any reason I
should run the procedure via a batch file
call as opposed to launching the command
string directly?

[MLH]

Good points.

[Terry Kreft]

Two possible reasons why
1) The environment (particularly the PATH) may be different in the cmd
shell as opposed to the windows shell
2) As ipconfig is a dos program it may just not like being run in this
way.

You could have tried
Call ShellWait(envir on$("comspec") & " /C ipconfig /all >c:\IPdata.txt" )

--
Terry Kreft

"MLH" <CR**@NorthStat e.net> wrote in message
news:19******** *************** *********@4ax.c om...

Thanks, Doug. Regarding the Randy Birch site, I thought you might
have been referring to the section on using INI files??? I found
nothing there though. Which part exactly were you talking about?

BTW, I seem to have run into a snag with ShellWait...
Call ShellWait("ipco nfig /all >c:\IPdata.txt" ) DID NOT WORK!!!
ShellWait ("ipconfig /all >c:\IPdata.txt" ) DID NOT WORK!!!
#AND#
Call ShellWait("c:\P rogram Files\TPSCG\Get Conf.bat") WORKED!
ShellWait ("c:\Program Files\TPSCG\Get Conf.bat") WORKED!

I don't understand. The batch file GetConf.bat contains the same CMD
string ipconfig /all >c:\IPdata.tx t but I've tested and the
file "IPdata.txt " is not being created using the syntax in the first
two cases.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxx

On Tue, 13 Dec 2005 10:14:19 -0500, "Douglas J. Steele"
<NOSPAM_djsteel e@NOSPAM_canada .com> wrote:

No reason that I can think of.

What are you trying to accomplish, by the way? It may be that you can
retrieve whatever you want without having to resort to those contortions.
Take a look at what Randy Birch has at
http://vbnet.mvps.org/code/network/index.html

(ObWarning: Randy's site is aimed at VB programmers, not Access
programmers .
There are significant differences between the controls available on forms
in
VB vs. those available on forms in Access. Consequently, not all of the
GUI-related code on Randy's site will port into Access)

[MLH]

On Tue, 13 Dec 2005 16:25:18 -0000, "Terry Kreft"
<te*********@mp s.co.uk> wrote:

Two possible reasons why
1) The environment (particularly the PATH) may be different in the cmd
shell as opposed to the windows shell Thx Terry. I checked the path this way: Click Start, Run, "CMD" and
typed Path. C:\WINDOWS\Syst em32\ was in the path and IPconfig.exe
is there.
2) As ipconfig is a dos program it may just not like being run in this
way. You're probably right with this one.

You could have tried
Call ShellWait(envir on$("comspec") & " /C ipconfig /all >c:\IPdata.txt" )

I would like to explore this, but am unsure what's meant by environ$
and comspec.

[MLH]

Its also worth mentioning the following...

Shell("ipconfig /all >c:\IPdata.sys" ) does not work from VBA
Click Start, Run then ipconfig /all >c:\IPdata.sy s doesn't either
Nor does Start, Run c:\windows\syst em32\ipconfig /all >c:\IPdata.sy s

Now the batch file, on the other hand, seems to have no problems...
Shell("c:\Progr am Files\TPSCG\Get Conf.bat") works
Click Start, Run then c:\Program Files\TPSCG\Get Conf.bat works
And of course Call ShellWait("c:\P rogram Files\TPSCG\Get Conf.bat")
works too (obviously)

All produce the desired file...

Directory of C:\
12/13/2005 11:52 AM 877 IPdata.sys
1 File(s) 877 bytes
0 Dir(s) 9,338,142,720 bytes free

[Terry Kreft]

Environ$ is a VBA function which returns the values of environment strings.

So
Environ$("Path" )

returns the Path environment string

Comspec is the environment string which holds the path to your command line
interpreter, so on my current machine
Environ$("comsp ec")

returns
C:\WINDOWS\syst em32\cmd.exe

The /C is a switch to cmd.exe to say run the command and then close.

Therefore on my machine
environ$("comsp ec") & " /C ipconfig /all >c:\IPdata.tx t"

translates as
C:\WINDOWS\syst em32\cmd.exe /C ipconfig /all >c:\IPdata.tx t
--
Terry Kreft

"MLH" <CR**@NorthStat e.net> wrote in message
news:hb******** *************** *********@4ax.c om...

On Tue, 13 Dec 2005 16:25:18 -0000, "Terry Kreft"
<te*********@mp s.co.uk> wrote:

Two possible reasons why
1) The environment(par ticularly the PATH) may be different in the cmd
shell as opposed to the windows shell

Thx Terry. I checked the path this way: Click Start, Run, "CMD" and
typed Path. C:\WINDOWS\Syst em32\ was in the path and IPconfig.exe
is there.

2) As ipconfig is a dos program it may just not like being run in this
way.

You're probably right with this one.

You could have tried
Call ShellWait(envir on$("comspec") & " /C ipconfig /all

>c:\IPdata.txt" )

I would like to explore this, but am unsure what's meant by environ$
and comspec.

[Douglas J. Steele]

The page I sent you to doesn't have anything about INI files.

It has a number of different code snippets to get you information about IP
addresses, MAC addresses, DNS and DHCP servers and the like. Since that's
typically the type of information I'm looking for when I run ipconfig /all,
I thought you might be able to get the information you were looking for
directly.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"MLH" <CR**@NorthStat e.net> wrote in message
news:19******** *************** *********@4ax.c om...

Thanks, Doug. Regarding the Randy Birch site, I thought you might
have been referring to the section on using INI files??? I found
nothing there though. Which part exactly were you talking about?

BTW, I seem to have run into a snag with ShellWait...
Call ShellWait("ipco nfig /all >c:\IPdata.txt" ) DID NOT WORK!!!
ShellWait ("ipconfig /all >c:\IPdata.txt" ) DID NOT WORK!!!
#AND#
Call ShellWait("c:\P rogram Files\TPSCG\Get Conf.bat") WORKED!
ShellWait ("c:\Program Files\TPSCG\Get Conf.bat") WORKED!

I don't understand. The batch file GetConf.bat contains the same CMD
string ipconfig /all >c:\IPdata.tx t but I've tested and the
file "IPdata.txt " is not being created using the syntax in the first
two cases.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxx

On Tue, 13 Dec 2005 10:14:19 -0500, "Douglas J. Steele"
<NOSPAM_djsteel e@NOSPAM_canada .com> wrote:

No reason that I can think of.

What are you trying to accomplish, by the way? It may be that you can
retrieve whatever you want without having to resort to those contortions.
Take a look at what Randy Birch has at
http://vbnet.mvps.org/code/network/index.html

(ObWarning: Randy's site is aimed at VB programmers, not Access
programmers .
There are significant differences between the controls available on forms
in
VB vs. those available on forms in Access. Consequently, not all of the
GUI-related code on Randy's site will port into Access)