Running Python script fails
Hi,
I am trying to run a Python script from VBA as follows:
The Python script produces a text file with an array of 100 times 100 random numbers between 0 and 1 as follows:
Please Login or Register to view this content.
If I run the VBA macro, a window briefly flashes up, and then closes again. There is no text file output. If I call the Python code on its own, the output random_array_output.txt is generated.Please Login or Register to view this content.
How to resolve please?
Administrative Note:
Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.
With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).
Thank you for helping us to help you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Re: Running Python script fails
Originally Posted by Pak Mariman
Hi,
as this is a VBA forum why not doing it directly under VBA ?!
Python scripts need to run in a terminal. Locally executing the file won't work. You'll need to use Shell with something like;
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks