DOS window displayed

[Guest]

I'm using the following code to run a bat file that downloads data that I
will import into my database. This works just fine.

Dim objShell As Object
Set objShell = CreateObject("Wscript.Shell")
Wait = True
objShell.Run "V:\FTP\GetDetail.bat", 1, Wait

When this code runs, the DOS window is displayed and the user can see the
commands being written. I would prefer that this be transparent to the end
user. Is this there some commad or code that I can use so the DOS window is
not visible to the end user. Thanks for the help........

 

[bob]

You might want to look at this if you are using FTP:

http://www.databasejournal.com/features/msaccess/article.php/3513061

Bob Galway

 

[Dirk Goldgar]

I'm using the following code to run a bat file that downloads data
that I will import into my database. This works just fine.

Dim objShell As Object
Set objShell = CreateObject("Wscript.Shell")
Wait = True
objShell.Run "V:\FTP\GetDetail.bat", 1, Wait

When this code runs, the DOS window is displayed and the user can see
the commands being written. I would prefer that this be transparent
to the end user. Is this there some commad or code that I can use so
the DOS window is not visible to the end user. Thanks for the
help........

You should be able to specify a window style to run the .bat file
minimized and keep the focus on the current active window. Try this:

objShell.Run "V:\FTP\GetDetail.bat", 7, Wait

 

[TC]

objShell.Run ..., 2, ...
opens minimized, I use that myself in a similar case.

HTH,
TC (MVP Access)
http://tc2.atspace.com