Parsing Shell Command with Parenthesis
 

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/

Parsing Shell Command with Parenthesis
 

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

Would be my guess although I don't know why autorun would need to be in
quotes. If not, you can try:

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

Adjust spacing for the /x Autorun to what it should be - it word wrapped in
your email, so I don't know what it should be.

--
Regards,
Tom Ogilvy


"GarethG" wrote in message
...
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/