VBAChromeDevProtocol
VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium (by PerditionC)
stdVBA
VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications. (by sancarn)
VBAChromeDevProtocol | stdVBA | |
---|---|---|
9 | 67 | |
61 | 318 | |
- | 1.9% | |
0.0 | 7.7 | |
about 2 years ago | 10 days ago | |
VBA | VBA | |
MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
VBAChromeDevProtocol
Posts with mentions or reviews of VBAChromeDevProtocol.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-02-18.
-
TabFS – a browser extension that mounts the browser tabs as a filesystem
I used to scan all the tabs in open browser windows to preserve all open URLs.
See also https://chromedevtools.github.io/devtools-protocol/ with Playwright et. al., even Excel VBA: https://github.com/PerditionC/VBAChromeDevProtocol
- The First Rule of Microsoft Excel: Don’t Tell Anyone You’re Good at It
-
Chrome Automation without Selenium
Use dev tools protocol
-
What problems have you solved with VBA?
Automating chrome via accessibility or via devtools protocol
-
Is .jsEval part of vanilla VBA or from a library of some sort? I googled and absolutely nothing came up in regards to this method.
If you're interested in XPath/ QuerySelectors, there is another VBA + Chrome project on Github which seeks to do much the same thing, though I haven't looked to see if there is jsEval equivalent, though there might be. But it definitely allows for QuerySelection of DOM elements; the following is an example from the project:
- IE automation with VBA
- Looking for something to do
- VBA And The WebDriver Dilemma
- [EXCEL] VBA Macro integration with Chrome.
stdVBA
Posts with mentions or reviews of stdVBA.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-11-15.
-
Why do people still use VBA?
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...)
-
Writing a Compiler is Surprisingly Easy (part 1)
You could have just treated everything as variant correct? That's what we do here: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda....
-
Is the era of the self-taught dev over?
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.
-
Best Practice in Aggregating Data
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.
-
How long have you been using VBA? What do you use it for at your job? Or for personal reasons
Sometimes, though more of a library / tool developer here. See stdVBA or stdVBA-examples
-
Why does VBA give general statement for errors and not exact?
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
-
Bulk Structured Spreadsheet Extractor
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.
-
A Fast and Simple Settings Management Module. Automatically sets everything up and works for PC or MAC
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 :)
-
[EXCEL] How do I get the accName of a control via AccessibleObjectFromWindow
Use stdVBA's stdAcc:
-
/r/VBA PSA: ChatGPT is incredibly good at writing basic VBA code if you give it clear instructions of what you want it to do and how
Explaining code in such a way that it codes the correct thing is pretty awful though... Let's try to do that for stdTimer.
What are some alternatives?
When comparing VBAChromeDevProtocol and stdVBA you can also consider the following projects:
integrate-palm-into-word - How to use Google's PaLM 2 language model in Microsoft Word.
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
Speed-Bionic-Reading - Speed reading technique that has recaptured public interest due to Bionic Reading done in a VBA Macro
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
stdVBA-examples
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA