Power-Refresh
VBA-CSV
Our great sponsors
Power-Refresh | VBA-CSV | |
---|---|---|
2 | 1 | |
67 | 19 | |
- | - | |
1.8 | 6.1 | |
about 2 years ago | 5 months ago | |
VBA | VBA | |
MIT License | 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.
Power-Refresh
-
Is it possible to auto-refresh without opening a workbook?
An overkill solution but i think its the best. you can search github for another scripts that either use VBA or powershell or python.
-
Automating Tedious Data Tasks
I came across this resource, which I haven't yet used myself, but seems potentially promising using a combination of some VBA code as well as an open-source scheduler: https://github.com/IvanBond/Power-Refresh/
VBA-CSV
-
A new year, a new tool to work with CSV files. Happy holidays!
I tried VBA-CSV, but I guess there is some Excel/Office specific code in there.
What are some alternatives?
Serial-Ports-in-VBA-Extra-Simple-2022 - Minimal Version
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
geo_vba - A geographic toolkit/library for VBA, excel etc.
QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
Vincenty-Excel - Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).
pacellman - Pac-Man in Excel
VBA_personal - Library with VBA, used in multiple projects.
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).
Excelerator - This is an Excel Addin for Windows that reads and writes data to Snowflake
csv2 - Fast CSV parser and writer for Modern C++