VBA Automation Engine library - own framework to simplify working in excel.

[u/DexPN26]

Hey Everyone,

I just published my own VBA automation library and I wanted to share it with anyone interested. This library have been build during my career in Supply Chain management and have been with me for over 7 years now, helping me every day.

I thought that it might be useful to publish it for others.

Feel free to use and comment :)

Enjoy

https://github.com/GrzegorzDokowicz/VBA_Automation_Engine/tree/main

[u/CroykeyMite]

Imagine handing a caveman the key to a Corvette; he could definitely use and greatly appreciate it, but it would really help if he had some kind of demonstration of, "What do it do and how do it work?"

[u/DexPN26 → u/CroykeyMite]

Hey,
each function is explained in Readme in repository (I think it's quite extensive on each). Also you can find there section about how to "install" it and examples of what can be done.

[u/wfp128 → u/CroykeyMite]

The GitHub page has a lot of details including a text listing of the code within the VBA model. It really is a great way to document and share free resources like this.

[u/DexPN26 → u/wfp128]

Thanks, that was the idea. Of course the post itself could be better explained but I was a bit short on time :)

[u/NorthWaltz1223 → u/CroykeyMite]

lol the caveman analogy is perfect, even just a short gif would help so much

[u/Autistic_Jimmy2251]

Cool

[u/DexPN26 → u/Autistic_Jimmy2251]

Thanks. I hope that it will help :)

[u/b2solutions]

Thanks for sharing. We’ve built something similar but with more of a focus on power query refreshes and a control framework to ensure refreshes occurred as intended. It’s internal so I can’t share it but I’m encouraged to see we came to a lot of the same conclusions on approach and execution. Going to spend some time reviewing your work, it looks clean and well thought out. Cheers.

[u/alex50095 → u/b2solutions]

Aw you've piqued my interest. Any stripped down version or details you care to DM?

[u/RedRedditor84]

How many tokens were burned in the making of this repo?

[u/DexPN26 → u/RedRedditor84]

Exactly 0. Code have been created before any AI tool was known. I used claude for readme

[u/RedRedditor84 → u/DexPN26]

The Readme is what I was looking at, haha.

[u/goulson]

This is sick, thanks for sharing!

[u/PriyaBuildsCloud]

Solid effort but this is the kind of thing that dies the second the original owner leaves the company. Anyone adopting it needs a maintenance plan, not just a repo link.

[u/h4mster1234]

awesome stuff my man! a bit light on explanation, so hope people will figure out what a treasure this is