|over 1 year ago||3 months ago|
|GNU General Public License v3.0 only||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.
I have 400 locations in Excel; how can I easily add their addresses into the same sheet?
1 project | reddit.com/r/excel | 24 Feb 2022
Apart from the mentioned solutions, you can try this code I wrote a while ago: https://github.com/krijnsent/geo_vba
Can I Create a Heat Map with Excel Data for a Downtown Area?
1 project | reddit.com/r/excel | 14 Jul 2021
As u/Grey_Patagonia_Vest describes: you could add some more information like a postal code to the address. If you're looking for "main street", that will give tons of hits, if you add a postal code and/or city there is a higher chance you get to your desired location/city. I've built this toolkit, based on OpenStreetMap / Nominatim to transform addresses to lat/long -> https://github.com/krijnsent/geo_vba , using the geo_nom_search function, you could give it a try.
Using VBA CSV interface to work with USA Cartographic Boundary Files (Shapefiles)
2 projects | reddit.com/r/vba | 20 Apr 2021
Not sure if it is of any use to you, but OSM has quite some data too. I have some code in a repository that could be of assistance: https://github.com/krijnsent/geo_vba
VBA - Filtering Arrays
1 project | reddit.com/r/excel | 3 Jul 2022
This is a great use case of VBA CSV Interface and its Filter method from the CSVArrayList class module.
Converting xlxs to csv without losing zeros
1 project | reddit.com/r/excel | 17 May 2022
Use VBA CSV interface, with it you can export worksheet data to CSV without any further data transformation.
Performing complex CSV data wrangling tasks with ease
1 project | reddit.com/r/vba | 27 Mar 2022
Compute 3P%. The first stage of our solution will be completed using the File System Object (FSO), so that we can indicate the path to the folder containing the data we wish to analyze. The desired goal can be achieved with very simple code. To complete the second stage, we will need to use a library that allows us to import, filter and handle results from different queries on CSV files; we will use for this purpose the CSV Interface library. Finally, we must compute the effectiveness of three-point shots made by LeBron James. It is clear that the task described is far from simple, but we will show that it can be achieved with readable, concise and extensible VBA code.
Advanced CSV filtering through VBA
2 projects | reddit.com/r/vba | 6 Mar 2022
After this publication, which details the reason why VBA Expressions turned out to be the most feasible option to solve the problem of integrating an expression evaluator with CSV Interface, it is time to address the process of integrating the evaluation capabilities and the ease with which this goal was achieved.
Fastest way to compare several hundred rows of data? [EXCEL]
1 project | reddit.com/r/vba | 22 Feb 2022
Maybe CSV Interface can help you. With this library you can read and import files in chunks (reducing memory usage). As well you can import one record at a time and perform your logic in order to determine which ones you want to append to memory.
Evaluating expressions from strings in VBA
4 projects | reddit.com/r/vba | 20 Feb 2022
In spite of what I discovered, I was convinced that I could incorporate the referred library to CSV Interface, so I dedicated myself to study the methodology with which variables are handled in stdLambda. I found it difficult to understand why the variables must be passed in terms of a pre-established order ($1 refers to the first value passed as parameter of the evaluate function, $4 the fourth... and so on). Thus, the user is forced to write the expressions taking into account the order in which the values will be passed.
3 projects | reddit.com/r/vba | 23 Dec 2021
If you want to do something really useful, you can contribute to one of the many amazing libraries around like stdVBA (you can see the backlog here), CSV Interface or VBCorLib
A new year, a new tool to work with CSV files. Happy holidays!
1 project | reddit.com/r/excel | 23 Dec 2021
If it's not too much to ask, I hope you will make this project your own and that it can support current and future members of this wonderful community and many others! Your recommendations, suggestions and constructive criticisms are welcome (I hope there will be many in this post), and you can also give stars in GitHub!2 projects | reddit.com/r/vba | 23 Dec 2021
The new release of CSV interface includes substantial improvements and changes to the way users interact with the tool, as well as fixing some programming bugs. What's new in the latest version?
VBA Import of CSV to Excel Sheet
1 project | reddit.com/r/excel | 15 Nov 2021
Use VBA CSV interface. The DumToSheet method can do the work. Here an example:
What are some alternatives?
QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
SFDX-Data-Move-Utility - The advanced Salesforce Data Loader SFDX Plugin (SFDMU) will assist you to populate your org (scratch/development/sandbox/production) with data imported from another org or CSV files. Supports Delete, Insert, Update and Upsert for multiple related sObjects.
csvdecoder - Go library for parsing and deserialising CSV files into Go objects
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).
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
EasyQuickImport - EasyQuickImport — Import transactions, invoices and bills into QuickBooks Desktop from Excel or CSV
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.
VBA-Better-Array - An array class for VBA providing features found in more modern languages
VBAUnicodeTools - Tools for working with Unicode in the VB Editor
VBA-CSV - Fast and convenient CSV reading and writing for VBA and Excel spreadsheets.