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
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: Passing Multiple Calculated Values to the Clipboard | reddit.com/r/vba | 2023-01-19
So firstly, I'd suggest to pass data to and from the clipboard you use stdClipboard
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.
An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
Library with VBA, used in multiple projects.
Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system. (by joyfullservice)Project mention: Distributing front-end file via SharePoint. | reddit.com/r/MSAccess | 2023-01-06
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.
Backus-Naur Form JSON Parser based on RegEx for VBA
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! | 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
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.
An Object-Oriented VBA experiment (by rubberduck-vba)Project mention: Is there a platform for selling Excel VBA games? | reddit.com/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.
QR Code generator library in VBA
Schedule refresh of any Excel file using open-source scheduler & refresher written on VBAProject mention: Is it possible to auto-refresh without opening a workbook? | reddit.com/r/excel | 2022-08-20
An overkill solution but i think its the best. you can search github for another scripts that either use VBA or powershell or python.
Wordle for Word 97Project mention: I Recreated Wordle in Microsoft Word | reddit.com/r/shittyprogramming | 2022-06-09
Looks (and probably works) better than my attempt with VBA :)
IP manipulation and lookup VBA functionsProject mention: Suggestions for a good IP range add/remove tool? | reddit.com/r/sysadmin | 2023-01-31
The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.Project mention: New version of VBA CSV Interface | reddit.com/r/vba | 2022-12-31
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.
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 | reddit.com/r/vba | 2022-12-16
Here's a code repo that I've had for years now.
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 tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
Fast and convenient CSV reading and writing for VBA and Excel spreadsheets.
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-01
And 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)
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.Project mention: Evaluate piecewise functions in VBA | reddit.com/r/vba | 2022-10-17
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.
Dictionary object that extends the Scripting.DictionaryProject mention: Update database with two similar workbooks | reddit.com/r/vba | 2022-02-02
If you're working with dictionaries, this might help.
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-25
Maybe 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.
A geographic toolkit/library for VBA, excel etc.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
Tools for working with Unicode in the VB Editor
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
1 project | reddit.com/r/vba | 19 Jan 2023
Where/How do you take track of notes
1 project | reddit.com/r/vba | 16 Dec 2022
VBA Username and Password Regex (MS Access)
1 project | reddit.com/r/visualbasic | 2 Dec 2022
Modifying excel files on Sharepoint/Microsoft Teams.
1 project | reddit.com/r/vba | 29 Nov 2022
[Cries in VBA]
1 project | reddit.com/r/ProgrammerHumor | 21 Oct 2022
Evaluate piecewise functions in VBA
1 project | reddit.com/r/vba | 17 Oct 2022
Solving systems of linear equations with VBA
1 project | reddit.com/r/vba | 15 Oct 2022
A note from our sponsor - SonarQube
www.sonarqube.org | 1 Feb 2023
What are some of the best open-source Vba projects in VBA? This list will help you: