VBA to command prompt - sending multiple commands to same line?

Good day all... hoping for a little help with the syntax on this one. An associate of mine created a phenomenal mini application in Python, which we can run from a command prompt manually. I'm trying to integrate his application into a spreadsheet our group has been using for quite some time now.

Other than opening a dos prompt and doing a "pushd" to map a network drive, I got nothing. And nothing I'm doing is working. And nothing I've read is helping.

I don't think this should be terribly difficult, but... well, for me it is.

I'm trying to do the following:
From VBA, open the Command window, which seems to work with

VBA.Shell "C:\WINDOWS\system32\cmd.exe"

- Once the DOS window is open, I need to change directories to, something like
"\\Corp.Bloomberg.com\Pn-dfs\q_search\"

- I need to then execute this line
"q_search.exe small_set.txt"

- Wait until the dataset is loaded (small_set.txt)

From here the script allows some user input, which it then processes (n-gram string searches done via Python), then outputs the data to a file, which I will import back into my spreadsheet.

Hope that makes sense - and thank you for any help!

JP

You can use Shell but it will run asynchronously so the rest of your code will not wait for it to finish - is that an issue?

Untested as I am on the road currently, so using my cell, but something like

shell "cmd.exe /c \\Corp.Bloomberg.com\Pn-dfs\q_search\q_search.exe \\Corp.Bloomberg.com\Pn-dfs\q_search\small_set.txt"