I need to import data from the census.gov website, specifically historical data. Building Permits Survey > Permits by Metropolitan Area This is the query interface for the website. It creates data sets that look like this. http://www.census.gov/construction/bps/txt/tb3v201401.txt I noticed that the query generates the same urls for the same query every time and was able to figure out the logic behind it. In the example above "tb3v201401" is the section that changes. t is always required and stands for table. 3 is also always required. y stands for year to date, no value is used for current month. V stands for valuation and U for units. The year of the query comes next in this case 2014 followed by the month in a two digit format.
With all that explained what I need is a way to quickly import the year to date December units from now until at least 1980. So a macro that could change the 2014 in the import minus one year and save to a new sheet would be perfect.
With all that explained what I need is a way to quickly import the year to date December units from now until at least 1980. So a macro that could change the 2014 in the import minus one year and save to a new sheet would be perfect.
