I have an Excel 2010 Web Query that is taking a fairly long time to format the data (Excel Macro runs slow). After stepping through the process (ASP to Text file then a Excel Template that runs the VBA Macro) with timing routines, I could narrow it down to Excel page formatting.
Today, being a newbie on your site, I located the following solution:
It runs much faster if I change "my" printer driver to something else, however, I was wondering if there is a VBA code solution for this?
My thinking is that turning off the default printer driver then back on, should work?
Thanks in advance,