Last seen: Sep 12, 2025
Hi David, Yes, it'll keep going until it encounters a blank cell in Col B. Regards Phil
Hi Vinod, I can see that you are trying to get something from the NSE website but I don't know exactly what it is you are trying to do. Please g...
No worries Yousef. Maybe when we're all out of lockdown you can buy me a take-away 🙂 Don't be afraid to try some code modifications. You can alw...
Forgot to say that the code uses FSO (FileSystemObject) so in order for it to work you'll need to set a reference in the VBA Editor to the Microsoft S...
Hi David, Attached is some code that will create a folder structure based on the contents of the sheet. You can probably work out for yourself how ...
Hey Yousef, Did you try doing that yourself? 🙂 It only took another IF .. THEN statement - see attached. Regards Phil
Hi, Can't see any reason on the face of it why it wouldn't work inside a Citrix session. But I don't know what restrictions are in place in your s...
You're welcome Yousef. Not sure what is causing your bugs without seeing the code you have changed. Could be invalid characters in the filenames...
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...
Hi Pa, The data laid out in your screenshot isn't the same as the data in the workbook you provided. The workbook I'm attaching here duplicates ...
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...
Hi Yousef, Please start your own topic, don't tag on to the end of an existing one 🙂 Attached is a workbook that does what you requested. I've...
Hi Rob, As I don't have a Mac there's no way for me to integrate my code with Ron's and test that it works. You can try contacting Ron and seein...
Hi Henrik, Have you added the Python module names to your pyxll.cfg file as described here: Regards Phil