Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tips to speed up VBA with several workbooks open.
I was wondering if there are any tips out there to allow faster
execution of VBA with several workbooks open? For example, I have a macro that deletes some cells contents in five different sheets in the same workbook. With no other workbooks open it takes 2 seconds to complete. With other workbooks then it takes more than 10 seconds to complete. This is just an example. Obviously the fact that there are other workbooks open has an impact on the execution. Any way to speed up this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel2007; workbooks.count is not counting all open workbooks | Excel Programming | |||
Open an excel Book. How can I speed it up? | New Users to Excel | |||
Tool tips or screen tips | Excel Programming | |||
Tips for Minimizing size of Pivot Table workbooks | Excel Discussion (Misc queries) | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |