just-VBA VS stdVBA

I'd be happy to answer questions if you have any. Did you download the demo file for the FunWithListObjects?

The demo file can be downloaded from my github here: https://github.com/lopperman/just-VBA/blob/main/Misc/arraySearch.xlsx

I'm not the best at documenting -- but I've been working on that. If you want to keep an eye on things I build, just follow my just-VBA repo on github. You can also follow me on reddit if you want to see what I post about -- i tend to post a lot :-)

To that end, I created the pbLogging.bas module. It's reasonably commented, but feedback is welcome on that. Once imported into your project, you can immediately start logging by calling the pbLog function:

Download Functional Demo Workbook, or the code

author (c) Paul Brower https://github.com/lopperman/just-VBA

Descriptions and example of recommended usage are available in the RangeUpdateUtil.xlsm file, which can be found in this github location

What are some of the things in excel that you 'suffered' on a Mac? I'm coming at this from a curiosity standpoint. I've built quite a bit of tools/libraries over the past few years for Excel/VBA. 100% of everything I've done is Mac and PC compatible (feel free to check my post history or my just-VBA github project). The only thing that's a bit tedious is working with custom User Forms, but it can still be done.

To use in your project, import the 'pbSettings.bas' module, and the 'Dictionary.cls' class module (also available here). Calling a method will automatically set up the worksheet/listobject. (e.g. t ype '? pbSettings.KeyExists("Version")' in the Immediate Window)

Download Demo .xlsm File

I do RPA from VBA personally using IAccessiblity. See stdAcc (https://github.com/sancarn/stdVBA/blob/master/src/stdAcc.cls) and an example (https://github.com/sancarn/stdVBA-examples/tree/main/Example...)

You could have just treated everything as variant correct? That's what we do here: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda....

The responses I got was a mix. Some businesses didn't take me seriously because the main language I used was VBA. Some businesses claimed I was too eager and I "didn't have a life". No one seemed to care about the achievements I had made in the languages, like building a DSL in VBA, or this electron app. I did eventually get a job in another engineering firm though, where I spend 90% of my time to this day programming.

Really depends what you actually want to do and how neat (or fast) you want your code to be too... I typically use stdEnumerator and stdLambda from stdVBA.

Sometimes, though more of a library / tool developer here. See stdVBA or stdVBA-examples

That said it is effort. After building stdLambda which brings lambda syntax to VBA, I can tell you that error handling in this class is still trash. It's just a lot of effort to write good error messages, and handle all errors correctly. Still definitely an item on the TODO list, but will it ever be a priority? idk

Otherwise this library poses as an example of how to use stdVBA libraries. Libraries used in this project: stdEnumerator, stdArray, stdCallback, stdCOM, stdICallable, stdLambda, stdRegex.

If you want a solution though see stdSettings. There are both system and user settings. Users are bound by their domain, so should work across organisations :)

Use stdVBA's stdAcc:

Explaining code in such a way that it codes the correct thing is pretty awful though... Let's try to do that for stdTimer.