agarwaldvk
09-03-2008, 04:44 PM
Hi Everybody
I am led to believe that there is a significant adverse impact on the performance of the VBA program if the VBE is open.
I have various VBA based Excel applications that run for reasonably long period of time say anything between 1 and 8 hours, hence performance improvement is very significant. If something as simple as keeping the VBE closed can provide performance improvement to any degree - I would certainly love that!
Does anyone have any suggestions as to whether or not the VBE should be closed (when a VBA based application is running) or is it only ones personal preference to have the VBE open or closed when running VBA programs and wouldn't have any performance improvement one way or the other?
Thanks in advance.
Best regards
Deepak Agarwal
I am led to believe that there is a significant adverse impact on the performance of the VBA program if the VBE is open.
I have various VBA based Excel applications that run for reasonably long period of time say anything between 1 and 8 hours, hence performance improvement is very significant. If something as simple as keeping the VBE closed can provide performance improvement to any degree - I would certainly love that!
Does anyone have any suggestions as to whether or not the VBE should be closed (when a VBA based application is running) or is it only ones personal preference to have the VBE open or closed when running VBA programs and wouldn't have any performance improvement one way or the other?
Thanks in advance.
Best regards
Deepak Agarwal