This is how I would execute the following in a .BAT file:

"N:\Apps\Opera Reports\Office\MSACCESS.EXE" K:\ExpCurMonth.mdb /x
"Autorun"

However, if I try to use
Shell("<Above Line", 0)

in VBA it moans about the ".

For now I just call the .Bat file, but the zero hides the command
prompt window and not the Access window.

I want to run the above command line and also hide the Access window
using zero in the shell command.

Any takers?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/