How to set PythonPath/ UDF_Modules?
<p>I have been trying to build my own Excel functions using Xlwings.</p>

<p>Using </p>

<pre><code>$ xlwings quickstart myproject 
</code></pre>

<p>would create a Python script in the same directory as the Excel xlsm file.</p>

<p>I want to put the Python script anywhere I want, like "D:\test0.py", so I did this on VBA Function Settings:</p>

<pre><code>PYTHONPATH = "D:\test0.py"
UDF_MODULES = "test0"
</code></pre>

<p>Except for these two lines, I didn't change anything in Function Settings. </p>

<p>I got  </p>

<blockquote>
  <p>ImportError: No module named 'test0'</p>
</blockquote>

<p><a href="https://i.stack.imgur.com/ZAH7m.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZAH7m.png" alt="enter image description here"></a></p>

<p>How do I import module from "D:\test0.py"?    </p>