Hi All,

Using FSO l am looping thru approx 30 files in a folder and retrieving
data. Additionally in each of the files there is an error checker so l
thought it would be a good idea to run the error checker and retrieve
the number of errors at the same time.

It all works fine apart from 'ScreenUpdating'. If l run the macro
without this code snippet (which runs the error checker) there is no
screen updating whatsoever as it was set to FALSE and has not been
switched back on again.

If l run the code with the code snippet the 'window' is constantly
switching between the 2 open workbooks as each file in the folder is
opened.

Is there a way round this??

CODE SNIPPET:
Application.Run (myFN & "!Unprotect")
Application.Run (myFN & "!ErrCheck")
SendKeys "{ENTER}", False
ErrorNos = mybook.Sheets("Start Here").Range("D28").Value

Sorry about the SendKeys but it is needed to respond to a MsgBox in
the ErrCheck macro. Unless anybody knows a better way?

Regards

Michael Beckinsale