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
I don't think this should be terribly difficult, but... well, for me it is.
I'm trying to do
From VBA, open the Command window, which seems to work with
- Once the DOS window is open, I need to change directories to, something like
- I need to then execute this line
- 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!