Using VBA CSV interface to work with USA Cartographic Boundary Files (Shapefiles)

This page summarizes the projects mentioned and recommended in the original post on reddit.com/r/vba
#Vba #vba-array #csv-files #Openstreetmap #vba-csv

Our great sponsors
  • SonarLint - Clean code begins in your IDE with SonarLint
  • InfluxDB - Build time-series-based applications quickly and at scale.
  • SaaSHub - Software Alternatives and Reviews
Our great sponsors

  • VBA-CSV-interface

    The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.

    Working from Notepad++ gave me an idea of how the text strings should be manipulated from VBA. The first thing to do from the VBA CSV interface will be to import only the fields that contain the relevant data to solve the problem (the_geom and NAME). The files created in this step (temporary) will be saved in the same folder.

  • geo_vba

    A geographic toolkit/library for VBA, excel etc.

    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

  • SonarLint

    Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts