Nov-13-2018, 05:32 PM
Good day, let me first apologize for any incorrect terminology below. I'm neither a python user nor a network engineer. I hope there is enough detail in my query, but if not, I'm happy to answer whatever questions I can.
I am currently working on a project that is a hybrid between VBA, SQL, and Python. It was originally written entirely in VBA and SQL, but I was hoping to take advantage of some python libraries to help with some of the heavy lifting (that is, serve as the engine component of the end to end we're building).
The handshakes between the two sides are largely worked out, but I'm fearing a bit of an implementation problem and am hopeful there is a reasonable solution. With users in various locations with different versions of python installed (or, like myself, none at all) and the complexities involved in getting compatible versions running across so many PC's, I'd like to explore the possibility of installing python and the required libraries on a network drive, but I'm getting various responses from my teammates.
Everybody involved has a PC with Windows 10, and the same version of Excel (2016, 64 bit). We all have access to the same network drives, and I can pass the path to the executable and arguments from VBA to launch the python script. Since the network drives are on the same domain, there is no issue with firewalls. We do not anticipate multiple people running the scripts simultaneously, if that makes a difference.
So - is it possible to install some version of python and the required libraries to a shared network drive/repository, and have it run as it would on an individual PC?
Thanks for any feedback!
I am currently working on a project that is a hybrid between VBA, SQL, and Python. It was originally written entirely in VBA and SQL, but I was hoping to take advantage of some python libraries to help with some of the heavy lifting (that is, serve as the engine component of the end to end we're building).
The handshakes between the two sides are largely worked out, but I'm fearing a bit of an implementation problem and am hopeful there is a reasonable solution. With users in various locations with different versions of python installed (or, like myself, none at all) and the complexities involved in getting compatible versions running across so many PC's, I'd like to explore the possibility of installing python and the required libraries on a network drive, but I'm getting various responses from my teammates.
Everybody involved has a PC with Windows 10, and the same version of Excel (2016, 64 bit). We all have access to the same network drives, and I can pass the path to the executable and arguments from VBA to launch the python script. Since the network drives are on the same domain, there is no issue with firewalls. We do not anticipate multiple people running the scripts simultaneously, if that makes a difference.
So - is it possible to install some version of python and the required libraries to a shared network drive/repository, and have it run as it would on an individual PC?
Thanks for any feedback!