About xlwings, the API for Excel VBA to use Python
Question: When I follow the instruction of xlwings up to:

    
    
    Sub MyMacro()
         RunPython ("import mymodule; mymodule.rand_numbers()") 
    End Sub  
    

It gives me error like: _can't find mymodule_. My understanding is this should
be an object from xlwings.

Why can't Excel find it and how should I correct this error?


Answer: Set the `PYTHONPATH` setting to the folder where `mymodule` is. Per default it
expects it to be in the same directory as your Excel file, see the
[docs](http://docs.xlwings.org/vba.html#settings).

