Hi,
The errorcode #Name? occurs when I am trying to use the files in one of your newsletter.
I have istalled Pyxll and Phyton. I havent done any chnages in the code.
Br
Henrik
Hi Henrik,
Have you added the Python module names to your pyxll.cfg file as described here:
https://www.pyxll.com/docs/userguide/udfs/introduction.html
Regards
Phil
Hi,
Yes I have.
It didn´t work, insted got I following error message: "moth_coin_rtd":No module name request
I still dont get how the function =coin_price_rtd(LOWER(A8)) is connected to the "moth_coin_rtd" Python module.
Thanks in advance
Br
Henrik
Hi Henrik,
Where did you get this error? In Excel? Pleas supply screenshots.
If you have the name(s) of the module(s) in the PyXLL config file, you also need to have the python module(s) 'moth_coin_rtd.py' in the PyXLL folder. The same folder as the pyxll.cfg file.
If it's still not working please attach your pyxll.cfg file, the python module(s) e.g. moth_coin_rtd.py and the Excel workbook.
Regards
Phil
Thank you Phil,
I really appricate your support.
After started over from the begining, reinstalled Python and PyXLL, I managed it make to work properly.
Is the function 'coin_price_rtd' a premade class whitin the PyXLL? How does the function know, that I will send the argument to the Python module 'moth_coin_rtd' ?
Br
Henrik
Hi Henrik,
coin_price_rtd is the Python function I wrote and this is stored in the file moth_coin_rtd.py. Open moth_coin_rtd.py and you'll see the function code.
PyXLL makes the function coin_price_rtd available to Excel - it essentially acts like a bridge between Excel and Python.
Regards
Phil