Exporting Data Automatically from Excel VBA

[dutchmenqb]

I am working with a survey on the Survey Monkey website for gathering data to put into an Excel sheet that creates a scorecard. However, I want to automate the entire process, and I have been able to get everything but the initial data pull. I was wondering if anyone knew a way (whether a third-party, using VBA code, whatever) to get into Survey Monkey, export the data, and save it automatically into a folder.

I believe I am unable to use the process of getting external data from web on the Data tab - the data on Survey Monkey does not appear as a table.