Hi all
I know of several ways to copy a sheet from a closed workbook, but i am struggling to find a very fast way....
My following code works, but it takes about 15 seconds to run (ideally I would like this under 5 seconds).
The sheet it is copying only has about 230,000 rows of data.
I really hope someone can help me speed this up! or direct me to another method?
Please Login or Register to view this content.
I suggest you disable all events, calculations etc before you open the workbook, if it isn't necessary then you can also set update links to false in the workbook open parameter and open it read-only
when closing that workbook add the Boolean False so just in case it won't prompt you to save.
Might speed it up a little.
Keep in mind that the file location (network drive or NAS) can slow things down too.
Hope this helps
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks