Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use the "shell" command? | Excel Discussion (Misc queries) | |||
Shell Command to initiate Linux program | Excel Programming | |||
SHELL command | Excel Programming | |||
How can you wait for the SHELL command to terminate ? | Excel Programming | |||
Copying a file with VBA (or with a SHELL command) | Excel Programming |