Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free. 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.
Project mention: Passing Multiple Calculated Values to the Clipboard | reddit.com/r/vba | 2023-01-19So firstly, I'd suggest to pass data to and from the clipboard you use stdClipboard
-
SonarQube
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
-
-
-
msaccess-vcs-integration
Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system. (by joyfullservice)
This is similar to what I was thinking of doing but was just curious if because of the way SharePoint works with the user directories if I could pop an update into the folder and it would resync with the new version whenever I may updates. If it doesn't indeed play well I've got a VBA script that checks to make sure the an FE file variable matches a table in the backend and if not prompts them to update to the newest version. I've also been using msaccess-vcs-integration and it's been a life saver.
-
-
Project mention: I’m making a vbaProject.bin packager in python and looking for anyone with opinions! | reddit.com/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
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
-
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
Project mention: Is it possible to auto-refresh without opening a workbook? | reddit.com/r/excel | 2022-08-20An overkill solution but i think its the best. you can search github for another scripts that either use VBA or powershell or python.
-
Looks (and probably works) better than my attempt with VBA :)
-
Project mention: Suggestions for a good IP range add/remove tool? | reddit.com/r/sysadmin | 2023-01-31
-
VBA-CSV-interface
The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
As usual, at the end of the year, a new version of VBA CSV Interface is available. However, this time it is a major revision focused on refactoring code and increasing the usability of the tool.
-
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.
-
Vincenty-Excel
Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).
Project mention: calculate distance using latitude and longitude excel | reddit.com/r/excel | 2022-09-14 -
Export-MS-Project-to-MS-Excel
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).
-
-
JustMoreVBA
A collection of code snippets, modules, and classes that I've written and collected over the years.
Project mention: [POWERPOINT] Save slides to a new PowerPoint without opening a temporary PowerPoint (Presentation1) window | reddit.com/r/vba | 2022-10-01And if all else fails, use a Win32 API and bruteforce your way through until you get your own way... that's what I do!! (link)
-
VBA-Expressions
A powerful string expression evaluator for VBA, which puts more than 60 mathematical, financial, date-time, logic and text manipulation functions at the user's fingertips.
So, if a Dominican needs to calculate the taxes that will be charged to them monthly, they should take pencil and paper, compute the annual amount of income and apply the corresponding formula, or they can use the following code in conjunction with VBA Expressions and get their result in a simple way.
-
If you're working with dictionaries, this might help.
-
ECPTextStream
ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
Project mention: [Access] Any alternatives to Scripting.TextStream that eat up less memory? | reddit.com/r/vba | 2022-05-25Maybe the ECPTextStream class module can help you. This library is faster than the scripting method when dealing with text files and can manage files up to 2GB without any problem. See the benchmarks here.
-
Project mention: I have 400 locations in Excel; how can I easily add their addresses into the same sheet? | reddit.com/r/excel | 2022-02-24
Apart from the mentioned solutions, you can try this code I wrote a while ago: https://github.com/krijnsent/geo_vba
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
VBA Vba related posts
- Passing Multiple Calculated Values to the Clipboard
- Where/How do you take track of notes
- VBA Username and Password Regex (MS Access)
- Modifying excel files on Sharepoint/Microsoft Teams.
- [Cries in VBA]
- Evaluate piecewise functions in VBA
- Solving systems of linear equations with VBA
-
A note from our sponsor - SonarQube
www.sonarqube.org | 1 Feb 2023
Index
What are some of the best open-source Vba projects in VBA? This list will help you:
Project | Stars | |
---|---|---|
1 | VBA | 285 |
2 | stdVBA | 168 |
3 | crypto_vba | 148 |
4 | VBA_personal | 113 |
5 | msaccess-vcs-integration | 101 |
6 | VBA-JSON-parser | 90 |
7 | VBA-Better-Array | 81 |
8 | Battleship | 72 |
9 | QRCodeLibVBA | 60 |
10 | Power-Refresh | 57 |
11 | wordle97 | 56 |
12 | VBAIPFunctions | 51 |
13 | VBA-CSV-interface | 45 |
14 | VBA-General | 41 |
15 | Vincenty-Excel | 36 |
16 | Export-MS-Project-to-MS-Excel | 16 |
17 | VBA-CSV | 15 |
18 | JustMoreVBA | 12 |
19 | VBA-Expressions | 10 |
20 | VBA-ExtendedDictionary | 9 |
21 | ECPTextStream | 6 |
22 | geo_vba | 5 |
23 | VBAUnicodeTools | 4 |