There is too reasons why the macro is taking a long time

1) If the worksbooks are large it will take time to open and close theh
workbooks

2) You are searching all the subdirectories (Me.SrcDir and subfolders)
which can take a very long time.

The one question I have is how long does it take to open any of these
workbooks by themseleves. Then multiply this number by the number of
workbooks you are opening.

You may havve a problem on your PC with opening any workbook. try
opening one of these workbooks on another PC and see if it also takes a
long time. You may havve a problem on your PC that needs to be fixed.

Also if you are trying to open the workbooks froom a Network drive this
could also slow down the macro.

You may also have INDEXING enabled on your PC or Newwork drive that is
slowing down the process and turing off Indexing may help.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=189852

http://www.thecodecage.com/forumz/chat.php