I have a bit of code that is simply importing data from access into MS Excel. On my laptop it always worked instantly. The whole code ran in about 1 or 2 seconds. It worked this well for a very long time. About 7 months ago the time pushed out to 25 seconds or so. I thought it was a server...
I run VBA in Excel all the time to get the following result, but obviously run out of room quickly. I have yet to figure out how to do it in Access.
I've included a sample table, Combined...are the desired results, as well as the excel vb code I use
****************************
Part Region...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.