Optimize VBA code, add more tables to download?

**snuffnchess** · 04-09-2016, 06:32 PM

Through google searches and help in these forums I have been able to piece together the below VBA code.

Basically right now, it tells excel to connect to a DB table NDA, downloads the data to Sheet 1, (called Hidden), and then copies most of that code to Sheet 2 (called Tariff).

Is there a better way to execute this function? It seems to work relatively quick now... but thought that if it were better optimized it may be faster/easier on the computer to run?

I would like the code optimally, to access another table in the DB, and download that data as well (and then have it copied to Sheet 2). Is the only way for me to accomplish this to merge the tables within the DB? Or Can it download the data from say NDAS 2 lines below where NDA's download ends?

Please Login or Register  to view this content.

**dflak** · 04-10-2016, 10:28 AM

I opened the workbook and didn't find a database connection. However I'll offer a suggestion.

Change this line

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Where TableName is a defined name of a cell in the workbook. So enter in the new table name in this cell when you want to run the query from another table in the same database.