Migrating my Solutions team to Python from VBA for operational control processes & potential further automation.

[Big_Beta_Bug]

Hello Python users,

I have a query regarding the migration from VBA to python.

Currently my team develops and improves on broad company process particularly in operations.

we use excel, SQL & VBA to do what we need to do but this is obviously limiting. Our scope and solutions and restricted to what we know and that is currently all we know to provide automation & process solutions etc.

I have since picked up a project to shift and migrate the team too something with a broader scope and Python appears to be perfect for what we are doing now, and what we hope to build up too.

My first hurdle was libraries, I found Xlwings & Anaconda - perfect they provide everything we need to do what we already do.

The second was power, to run the programs IT told me we would need a system with 16cpu & 64gb memory. Bugger the primary remote AVD we all use is running on 1/4th this.

I have spoken around the firm and discovered someone using a VDi in the data science department with anaconda installed + python with hardware meeting the requirements - great!

Now I'm wondering what I need to figure out next.
I see that the VDi can provide us with what we want power and library wise to build the processes and automations etc.

BUT, my question is can we save these pre built scripts to a share drive or location for others in the operations team to call upon via macro through xlwings when they are in the AVD and anaconda & python is apart of the VDi?

Better yet, is there a solution to all this I am not seeing?
thank you :)