It is incredibly helpful to be able to look at what you all are doing with Excel!Not only did I see a huge variety in how Excel is being used, you also pointed out various tips and tricks for writing fast VBA code in Excel.I would like the queries to be invisible while they are running, but currently the user sees 50 query windows open/close which is ugly.
The functionality depends on Word, not on the Automation client.
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.
You'll be able to ask any tech support questions, or chat with the community and help others.
If you think I missed an important concept for how to optimize Excel VBA performance, or if you’ve got a valuable comment or link to share, please feel free to post here so everyone can benefit. Turn Off Everything But the Essentials While Your Code is Running This optimization explicitly turns off Excel functionality you don’t need to happen (over and over and over) while your code runs.
Note that in the code sample below we grab the current state of these properties, turn them off, and then restore them at the end of code execution. Display Page Breaks = False ‘note this is a sheet-level setting ‘: This setting tells Excel to not redraw the screen while False.