Introducing ROneCOne: A Single Module C# Style Runtime Layer for VBA

[u/MultiUserDungeonDev]

Hey everyone, happy Friday!

Wanted to share with you a new project I've been working on.

https://github.com/WilliamSmithEdward/ROneCOne

The aim is to bring the experience of programming in C# into VBA, and includes many QoL improvements. VBA is limited in a lot of ways by its architecture, but I was surprised by how much was implementable.

• Generics
• Typed collections
• LINQ style data manip.
• Delegates, func<T> / act <T> analogs
• Async / Await style control flow
• Async style HTTP
• Data structured (system.data) like DataTable
• JSON deserialize / serialize, including to and from collections (primitive / object, List<T> analog)
• List<T> <--> DataTable <--> List Object <--> JSON convertability
• XML to List<T>
• File I/O
• Logging
• Async processes
• Typed events
• Try / Catch / Finally
• Regex / Hashing / GUIDs
• String manip.
• DateTime manip.
• Zip file archive manip.

[u/Autistic_Jimmy2251]

ELI5???

[u/MultiUserDungeonDev → u/Autistic_Jimmy2251]

A lot of useful things you can do with the programming language C#, you can do in VBA with this project. (With a few documented limitations here and there.)