Top 8 vba-macro Open-Source Projects
Code Blocks relating to everything VBA (by AllenMattson)
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
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).
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
Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
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
How to use Google's PaLM 2 language model in Microsoft Word.Project mention: How to access PaLM in MS Word | /r/singularity | 2023-06-12
Instructions on how to set this up here
Updating dependencies is time-consuming.. Solutions like Dependabot or Renovate update but don't merge dependencies. You need to do it manually while it could be fully automated! Add a Merge Queue to your workflow and stop caring about PR management & merging. Try Mergify for free.
Some VBA macros for personal use
vba-macros related posts
What are some of the best open-source vba-macro projects? This list will help you: