just-VBA
stdVBA
just-VBA | stdVBA | |
---|---|---|
46 | 67 | |
29 | 257 | |
- | - | |
8.8 | 8.5 | |
12 days ago | 3 days ago | |
VBA | VBA | |
GNU General Public License v3.0 only | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
just-VBA
-
Settings Management that moves with your workbook and supports custom settings by OS and / or User
I'd be happy to answer questions if you have any. Did you download the demo file for the FunWithListObjects?
-
How to enable very fast wildcard searches on large tables
The demo file can be downloaded from my github here: https://github.com/lopperman/just-VBA/blob/main/Misc/arraySearch.xlsx
-
Quickest way to duplicate rows based on value in a column
I'm not the best at documenting -- but I've been working on that. If you want to keep an eye on things I build, just follow my just-VBA repo on github. You can also follow me on reddit if you want to see what I post about -- i tend to post a lot :-)
-
Are you logging? If not, consider dropping this module into your project and you'll be good to start logging immediately
To that end, I created the pbLogging.bas module. It's reasonably commented, but feedback is welcome on that. Once imported into your project, you can immediately start logging by calling the pbLog function:
-
Simplify deleting User-Selected ListObject Rows. Handles sheet protection, non-contiguous selection, databodyrange boundary control
Download Functional Demo Workbook, or the code
-
[Excel] autogenerate sheets for the entire month at the beginning of each month.
author (c) Paul Brower https://github.com/lopperman/just-VBA
-
Enable users to dbl-click a cell in a ListObject or regular range, and replace or clear all matching values in column, or fill blanks
Descriptions and example of recommended usage are available in the RangeUpdateUtil.xlsm file, which can be found in this github location
-
Suffering with Excel for Mac? Get Parallels.
What are some of the things in excel that you 'suffered' on a Mac? I'm coming at this from a curiosity standpoint. I've built quite a bit of tools/libraries over the past few years for Excel/VBA. 100% of everything I've done is Mac and PC compatible (feel free to check my post history or my just-VBA github project). The only thing that's a bit tedious is working with custom User Forms, but it can still be done.
-
A Fast and Simple Settings Management Module. Automatically sets everything up and works for PC or MAC
To use in your project, import the 'pbSettings.bas' module, and the 'Dictionary.cls' class module (also available here). Calling a method will automatically set up the worksheet/listobject. (e.g. t ype '? pbSettings.KeyExists("Version")' in the Immediate Window)
-
Map and Copy Rows from ListObjects or Range to a 'Master' ListObject or Range
Download Demo .xlsm File
stdVBA
-
Why do people still use VBA?
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...)
-
Writing a Compiler is Surprisingly Easy (part 1)
You could have just treated everything as variant correct? That's what we do here: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda....
-
Is the era of the self-taught dev over?
The responses I got was a mix. Some businesses didn't take me seriously because the main language I used was VBA. Some businesses claimed I was too eager and I "didn't have a life". No one seemed to care about the achievements I had made in the languages, like building a DSL in VBA, or this electron app. I did eventually get a job in another engineering firm though, where I spend 90% of my time to this day programming.
-
Best Practice in Aggregating Data
Really depends what you actually want to do and how neat (or fast) you want your code to be too... I typically use stdEnumerator and stdLambda from stdVBA.
-
How long have you been using VBA? What do you use it for at your job? Or for personal reasons
Sometimes, though more of a library / tool developer here. See stdVBA or stdVBA-examples
-
Why does VBA give general statement for errors and not exact?
That said it is effort. After building stdLambda which brings lambda syntax to VBA, I can tell you that error handling in this class is still trash. It's just a lot of effort to write good error messages, and handle all errors correctly. Still definitely an item on the TODO list, but will it ever be a priority? idk
-
Bulk Structured Spreadsheet Extractor
Otherwise this library poses as an example of how to use stdVBA libraries. Libraries used in this project: stdEnumerator, stdArray, stdCallback, stdCOM, stdICallable, stdLambda, stdRegex.
-
A Fast and Simple Settings Management Module. Automatically sets everything up and works for PC or MAC
If you want a solution though see stdSettings. There are both system and user settings. Users are bound by their domain, so should work across organisations :)
-
[EXCEL] How do I get the accName of a control via AccessibleObjectFromWindow
Use stdVBA's stdAcc:
-
/r/VBA PSA: ChatGPT is incredibly good at writing basic VBA code if you give it clear instructions of what you want it to do and how
Explaining code in such a way that it codes the correct thing is pretty awful though... Let's try to do that for stdTimer.
What are some alternatives?
VBA-Dictionary - Drop-in replacement for Scripting.Dictionary on Mac [Moved to: https://github.com/VBA-tools/VBA-Dictionary]
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
VBA - Code Blocks relating to everything VBA
VBAChromeDevProtocol - VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
VBA-Dictionary - Drop-in replacement for Scripting.Dictionary on Mac
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
VBA-StateLossCallback - A class that allows a callback when state is lost
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.
VBA-Project-Information - VBA Project Information
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.