Running Python script from Excel VBA Filepath Spaces

Question

I'm trying to run a Python script from Excel using this VBA script.

Sub Plot()

ChDir "M:\Tools and Utilities\ColorScout\ColorScout Data Parser\src"
Shell "C:\Anaconda3\python.exe M:\Tools and Utilities\ColorScout\ColorScout Data Parser\src\Main.py", vbNormalFocus

End Sub

Pretty basic.

However, it's failing on the second line. I get an error message from Python that M:\Tools is not a directory.

What I think is happening is that the spaces in "Tools and Utilities" aren't being recognized. How can I get Python to recognizes Tools and Utilities as a directory? Putting Tools and Utilities in quotation marks raises a syntax error in VBA.

Hope this makes sense. Thank you!

Try including the full parameter in quotations: "C:\Anaconda3\python.exe ""M:\Tools and Utilities\...\Main.py""" — paul bica
– paul bica, Commented Sep 17, 2015 at 2:19

paul bica · Accepted Answer · 2015-09-17 22:07:04Z

2

Include the full parameter in quotations:

Shell "C:\Anaconda3\python.exe ""M:\Tools and Utilities\...\Main.py"""

answered Sep 17, 2015 at 22:07

paul bica

10.8k4 gold badges27 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Running Python script from Excel VBA Filepath Spaces

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related