How do I path to a Python install using an Environment Variable from within an Excel / VBA macro?

Question

This works:

Path = "c:\Python27\python.exe"
File = ThisWorkbook.Path & "\Positionly-API-Keyword-Script.py"

This does not work:

Path = "%systemdrive%\Python27\python.exe"
File = ThisWorkbook.Path & "\Positionly-API-Keyword-Script.py"

What gives?

I just want to make my macro more flexible so that it will always find Python 2.7 if it was installed in the default directory (which may or may not be C:)

Ideally I'd like to just variable/path it straight to Python to make it mich more flexible and rigorous in terms of error handling. I just don't know the VBA to do what I want!

Thanks! That led me to try this: Path = Environ(systemdrive) & "\Python27\python.exe" - but no dice, it still doesn't work... — Studiumcirclus
– Studiumcirclus, Commented Apr 10, 2017 at 11:18

Sivaprasath Vadivel · Accepted Answer · 2017-04-10 11:17:11Z

2

path=environ("Systemdrive") & "\python27\python.exe"

you can use the Environ function to get operating system variables.

answered Apr 10, 2017 at 11:17

Sivaprasath Vadivel

5415 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

How do I path to a Python install using an Environment Variable from within an Excel / VBA macro?

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