Good Evening...
I am very new to VBA... have only been playing with it for about a week, and need to help to optimize a macro.
Currently it takes about 23 seconds for it to run... and was hoping to get it down a bit.
First step is a push button to "select file location" then one table from the DB is downloaded into a worksheet called "hidden" and finally columns B:L are copied from "hidden" to "UPS Tariff"
Any suggestions are greatly appreciated
Please Login or Register to view this content.
Hi
First thing i would do is
1.
Change adOpenStatic to adOpenForwardOnly, im not sure if this applies to reading data from a file but it certainly slows things down with a live database connection
2.
your looping through every cell in 'Sheet9.Range("B1:B762")' and checking that they dont contain all those values and multiplying it by 1!!!!!!!! is this correct?
this looks very slow, examine the code here and make these changes....
just try that first and post back here.Please Login or Register to view this content.
Avoid Select and Selection in your code. It's unnecessary and slows down your code. Use With ... End With instead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks