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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tips to speed up VBA with several workbooks open.
Have you tried turning off screenupdating and setting calculation to manual
? Tim wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tips to speed up VBA with several workbooks open.
I am using screenupdating all over the place yes...
Manual Calculation not so much, I will give it a try to see if it makes a difference. On Aug 11, 1:23*am, "Tim Williams" <timjwilliams at gmail dot com wrote: Have you tried turning off screenupdating and setting calculation to manual ? Tim wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tips to speed up VBA with several workbooks open.
Why does it slow so much with several workbooks opened with no links
between them? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tips to speed up VBA with several workbooks open.
On 11 Aug, 17:50, " wrote:
Why does it slow so much with several workbooks opened with no links between them? Maybe because for every change in ActiveWorkbook are recalculated all opened wbooks ...it's an ideea , I'm not shure. I has problems with delete of cell contents and I found that Range("...")ClearContents work faster than Range("...").Delete |
Reply |
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 |