stdVBA
VBAChromeDevProtocol
Our great sponsors
stdVBA | VBAChromeDevProtocol | |
---|---|---|
62 | 9 | |
215 | 47 | |
- | - | |
0.0 | 0.0 | |
about 1 month ago | 8 months ago | |
VBA | VBA | |
MIT License | MIT License |
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.
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
-
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 :)
- Creating a bot for automation.
-
Worst and best of VBA
Aha motivations for stdVBA which is a library I made. It resolves some of these points in some ways. E.G. stdLambda acts as a Lambda syntax for VBA. stdCallback allows you to ripe the benefits of first class functions, without those functions existing.
-
VBA like a proper dev?
my own stdVBA and some examples at stdVBA-UI
-
I created a fluent unit testing framework in VBA
There're numerous unit testors out there already. I do find it interesting as to why many prefer this result.equalTo(3) compared to result = 3. My own is a single class and goes down the Test.Assert message, x=y route. As a result most of my tests look like:
-
VBA And The WebDriver Dilemma
For sharepoint you need to use SOAP. I've got a small example here
-
Evaluating expressions from strings in VBA
At that point, I decided to try the fabulous stdLambda tool, developed by u/sancarn. I found that stdLambda correctly evaluated all the corner cases that made Volpi's class fail. This fact excited me, so I decided to measure the time it took to evaluate an expression with variables, noticing that the u/sancarn library was quite efficient. At that point, I started to measure the performance by evaluating functions like sin, cos, tan, abs, the results seemed strange to me when I noticed that the performance was almost 50 times lower when compared to the results obtained when measuring the performance by evaluating expressions without calls to built-in functions.
Here the explanation by the library owner:
VBAChromeDevProtocol
-
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
- IE automation with VBA
- VBA And The WebDriver Dilemma
What are some alternatives?
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
VBA-Unit-Tester
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
VBA-Project-Information - VBA Project Information
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.
VBAPackager - Based on Evil Clippy, designed to package VBA documents (WIP)
VBA-Web - VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
stdVBA-examples