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.
Bookmarks