stdVBA
VBA-CSV-interface
Our great sponsors
stdVBA | VBA-CSV-interface | |
---|---|---|
67 | 44 | |
247 | 58 | |
- | - | |
8.5 | 6.7 | |
12 days ago | about 1 month ago | |
VBA | VBA | |
MIT License | GNU General Public License v3.0 only |
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.
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.
VBA-CSV-interface
-
Creation of the CSV interface community
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.
-
Meet a library member: CSVTextStream, the king of performance.
To prove that we are capable to unlocks some performance limitations from traditional file processing approach, I decided to develop the CSVTextStream to gain advantage over native VBA's I/O functionalities, boosting the efficiency of text file reading up to 2 GB in size by use a buffered text stream technique. You can download the latest version from here.
-
A tool to empower VBA
This is by no means all the functionality that CSV Interface can provide. If you want to know more details, I invite you to read the documentation.
- CSV Interface GitHub repo
-
Is there a way to specify format when reading CSV files? Specifically, I'm struggling with delimiters and qualifiers
Your requirements are according to RFC-4180 specifications. There is no standard CSV format. This situation has led to the proliferation of CSV variations such as DSV, TSV... Creating a custom library to solve your problem can be a solution, you can also use other already developed and well tested libraries such as CSV Interface, a library that supports CSV according to RFC-4180 specifications and also DSV files using the Unix style scape sequence.
-
suggest amazing uses of macros VBA
VBA can solve, literally, every problem you can face in your daily routine. You can automate repetitive task and also expand the language to create complete utilities and offer others a solution to a common issue. For example, I created VBA CSV Interface to help users deal with data from CSV files.
-
Finding a quicker method for Concatenate
With CSV Interface this task can be done with easy. The library has a MergeField method that performs this specific task. Also you can shift fields and rearrange them as you wish.
-
New version of VBA CSV Interface
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.
-
Batch file to split CSV
This is a great use case of VBA CSV interface. Using the library you can split your file on related data and filter it out by column/field content.
-
Sorting data by values NOT being sorted?
Save your data as CSV and manage it from CSV Interface.
What are some alternatives?
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
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).
VBAChromeDevProtocol - VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
geo_vba - A geographic toolkit/library for VBA, excel etc.
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.
QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
VBA-Project-Information - VBA Project Information
VBA-Better-Array - An array class for VBA providing features found in more modern languages
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
csvdecoder - Go library for parsing and deserialising CSV files into Go objects