Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev. Learn more →
Top 23 VBA Vba Projects
-
-
stdVBA
VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
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...)
-
Onboard AI
Learn any GitHub repo in 59 seconds. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev.
-
-
msaccess-vcs-addin
Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system.
I use Access VCS. You export the database, front end or back end to a folder and then add it to a git repo from there. It will not save the data only the code, macros, forms, reports, queries, and table schemas.
-
-
Project mention: I’m making a vbaProject.bin packager in python and looking for anyone with opinions! | /r/vba | 2023-01-20
Hesitate to mention it because I haven't had time to look at the enhancement we talked about this weekend at all 😅 but yeah I do use a script like that to import the bas/cls files from the repo into a new workbook every time I do a pull request. https://github.com/Senipah/VBA-Better-Array/blob/master/scripts/createDevWorkbook.ps1
-
-
InfluxDB
Collect and Analyze Billions of Data Points in Real Time. Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.
-
-
-
Then you need to do some research, otherwise you won't know what you're competing with! Take, the example, the version of Arkanoid made by VB6 developer - https://imgur.com/a/Z8GL0hk There are a number of projects on Github - like BattleShips by the maker of RubberDuck (the VBA Editor COM addin), Mathieu Guindon. You should check out Awesome VBA because there a few games listed to get you started.
-
-
Power-Refresh
Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA
-
-
VBA-CSV-interface
The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
During this process, I also thought about how to offer the users of the tool a help channel where they can receive help, since the code project is currently maintained by a single person. This is why I decided to create the r/CSVinterface community, whose main objective is to serve as a help channel for CSV Interface users.
-
VBAChromeDevProtocol
VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
Project mention: TabFS – a browser extension that mounts the browser tabs as a filesystem | news.ycombinator.com | 2023-02-18I 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
-
VBA-General
A repository of various modules and classes for interacting with Excel and doing other... things.
Here's a code repo that I've had for years now.
-
Follow this guide to implement
-
Vincenty-Excel
Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).
-
Project mention: Settings Management that moves with your workbook and supports custom settings by OS and / or User | /r/vba | 2023-12-06
I'd be happy to answer questions if you have any. Did you download the demo file for the FunWithListObjects?
-
Speed-Bionic-Reading
Speed reading technique that has recaptured public interest due to Bionic Reading done in a VBA Macro
For WORD, several macros that can convert the styling of an entire file or selected text to a bionic-reading style. https://github.com/GPFSimon/Speed-Bionic-Reading
-
vscode-vba - Write vba code in VisualStudio Code. Add-in is mostly a syntax highlighter.
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
VBA Vba related posts
- Settings Management that moves with your workbook and supports custom settings by OS and / or User
- How to enable very fast wildcard searches on large tables
- Writing a Compiler is Surprisingly Easy (part 1)
- Is the era of the self-taught dev over?
- Best Practice in Aggregating Data
- How long have you been using VBA? What do you use it for at your job? Or for personal reasons
- Why does VBA give general statement for errors and not exact?
-
A note from our sponsor - Onboard AI
getonboard.dev | 8 Dec 2023
Index
What are some of the best open-source Vba projects in VBA? This list will help you:
Project | Stars | |
---|---|---|
1 | VBA | 382 |
2 | stdVBA | 229 |
3 | crypto_vba | 154 |
4 | msaccess-vcs-addin | 148 |
5 | VBA_personal | 132 |
6 | VBA-Better-Array | 100 |
7 | VBA-JSON-parser | 100 |
8 | QRCodeLibVBA | 77 |
9 | add-chatgpt-to-microsoft-word | 75 |
10 | Battleship | 72 |
11 | VBAIPFunctions | 66 |
12 | Power-Refresh | 64 |
13 | wordle97 | 57 |
14 | VBA-CSV-interface | 53 |
15 | VBAChromeDevProtocol | 50 |
16 | VBA-General | 46 |
17 | add-gpt-chatbot-to-microsoft-word | 41 |
18 | Vincenty-Excel | 39 |
19 | just-VBA | 26 |
20 | Speed-Bionic-Reading | 22 |
21 | vscode-vba | 19 |
22 | VBA-CSV | 18 |
23 | VBA-ExtendedDictionary | 16 |