how to improve this VBA code to make it faster
I use the code below, to import another large file into my template. it works but sometimes freezes and is slow.
am i doing something wrong on this code that causes freezing. is there a more efficient (neat) way to do this?
any help is appreciated.
Please Login or Register to view this content.
On this line..
you should be able to get rid of the 2 DisplayAlerts line since it is already disabled at the beginning of your code.Please Login or Register to view this content.
Also, the following line at the end of your code should be set to True instead of False.
I'n not sure if either of these will help speed it up though.Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks