Click here to Skip to main content
15,890,995 members
Articles / Programming Languages / Visual Basic

CSV Data Management: Unleashing the VBA Arrays Power

Rate me:
Please Sign up or sign in to vote.
2.60/5 (2 votes)
5 Jan 2023GPL36 min read 6.7K   132   4  
Turn Microsoft Office applications into a masterpiece for cleansing, reshaping, managing and analyzing data from CSV files. No more intermediary spreadsheets, no more headaches due to DLL updates that make your implementations stop working, the pure VBA solution is here.
In this article, we will approach CSV files from the perspective of the analysis of their content, urging within the different situations that require a management of them, while proposing a solution coded in VBA for a variety of common situations in the day to day of a data analyst, without calls to external DLLs or APIs, without intermediary objects other than those of Microsoft's macro language.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The GNU General Public License (GPLv3)


Written By
Dominican Republic Dominican Republic
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions