Relative path in Xlwings Pythonpath

Question

Is it possible to reference the python code in the parent folder of the current folder like this:

PYTHONPATH = "../../Python_Code"

It won't work on my computer. The objective is to avoid hard coded paths.

Answer 1

Indeed, you can set this like so:

PYTHONPATH = ThisWorkbook.Path & "/.."

You might need at least v0.7.0 though.