Syntax help - kick off .exe with 2 arguments?

[JP Romano]

Good day...having some trouble getting my syntax correct and hoping somebody here can assist me.

I have a python script which has been converted to an executable, and is sitting in a corporate network directory.
My VBA script is dumping 2 .txt files into that same directory, and I need to kick off the .exe using the two filenames as arguments for the python script. I keep getting "file not found" or "syntax error" at each step. For what it's worth, I can run the .exe without the arguments when we hard code the file names into the python script. Here's what I have

Please Login or Register  to view this content.

I've tried with and without quotes, commas, double sets of quotes and so on. Any idea what I'm doing wrong?

Thank you!

[rorya]

Typically it would be something like:

Please Login or Register  to view this content.

[Norie]

Couldn't you alter the Python script to prompt you to select the files?

[JP Romano]

rorya -thanks, I've been playing around with it, but can't get it to work. I've asked the python people to modify their code so we can print out the arguments it's getting/using into a console window - that will allow me, I hope, to see what I'm actually getting to it.

Norie - indeed that would be the route to use, but this python script is basically an engine that needs to be invisible to the user. In a nutshell, I have a spreadsheet with a couple of userforms that will be populated with data from 2 imported files. VBA will do some stuff, then ultimately, send 2 text files to a network drive. I will pass those filenames from VBA to the python script, which has been converted to an exe. When the python script finishes it's work, it will send two .csv files to that same network, and I will pick them back up from my VBA script.

[shg]

Here's my flail at this:

Please Login or Register  to view this content.

[JP Romano]

Thank you for the replies - working with the python guys to see if they can print out the arguments as they are getting them... we're making great progress...thanks!