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
Code Blocks relating to everything VBA (by AllenMattson)
VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.Project mention: Why do people still use VBA? | news.ycombinator.com | 2023-11-15
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...)
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.
An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system.Project mention: MS Access Version Control | /r/MSAccess | 2023-05-03
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.
Library with VBA, used in multiple projects.
An array class for VBA providing features found in more modern languagesProject 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
Backus-Naur Form JSON Parser based on RegEx for VBA
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.
QR Code generator library in VBA
How to add ChatGPT's Text Completion to Microsoft WordProject mention: Add ChatGPT to Microsoft Word | news.ycombinator.com | 2023-03-30
An Object-Oriented VBA experiment (by rubberduck-vba)Project mention: Is there a platform for selling Excel VBA games? | /r/vba | 2023-01-01
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.
IP manipulation and lookup VBA functionsProject mention: How to sort IP addresses with Excel? | /r/networking | 2023-04-17
Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA
Wordle for Word 97
The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.Project mention: Creation of the CSV interface community | /r/vba | 2023-04-08
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.
VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/SeleniumProject mention: TabFS – a browser extension that mounts the browser tabs as a filesystem | news.ycombinator.com | 2023-02-18
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
A repository of various modules and classes for interacting with Excel and doing other... things.Project mention: Where/How do you take track of notes | /r/vba | 2022-12-16
Here's a code repo that I've had for years now.
Create a chatbot in Microsoft Word powered by ChatGPTProject mention: Integrate GPT Chatbot into MS Word | /r/ChatGPT | 2023-03-28
Follow this guide to implement
Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).
VBA Utilities - 100% MAC & PC CompatibleProject 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 reading technique that has recaptured public interest due to Bionic Reading done in a VBA MacroProject mention: Game Changer! | /r/readwithme | 2023-04-19
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
VBA language extension to use with VS Code. Also used for syntax highlighting on GitHub.Project mention: Best code to build tools with for Excel | /r/excel | 2023-12-06
vscode-vba - Write vba code in VisualStudio Code. Add-in is mostly a syntax highlighter.
Fast and convenient CSV reading and writing for VBA and Excel spreadsheets.
Dictionary object that extends the Scripting.Dictionary
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
3 projects | /r/vba | 6 Dec 2023
How to enable very fast wildcard searches on large tables
1 project | /r/excel | 25 Nov 2023
Writing a Compiler is Surprisingly Easy (part 1)
5 projects | news.ycombinator.com | 7 Nov 2023
Is the era of the self-taught dev over?
1 project | /r/learnprogramming | 11 Jul 2023
Best Practice in Aggregating Data
1 project | /r/vba | 10 Jul 2023
How long have you been using VBA? What do you use it for at your job? Or for personal reasons
3 projects | /r/vba | 16 Jun 2023
Why does VBA give general statement for errors and not exact?
1 project | /r/vba | 16 Jun 2023
A note from our sponsor - Onboard AI
getonboard.dev | 8 Dec 2023
What are some of the best open-source Vba projects in VBA? This list will help you: