Opening other workbooks and ignoring their vba message boxes

[PTP86]

Hi

I've got a macro that opens hundreds of files and pulls data from them.

A few of the files contain a message box that pops up on opening to alert the user that "this file hasn't been updated for over a week"

When this happens it pauses the code of my macro until OK is clicked. Which means I can't go away and leave it to run.


Is there a way of preventing the other workbook's message boxes from appearing or disturbing things?
These are other people's files so I don't want to go deleting that opening message from their code

I've tried Application.DisplayAlerts = False but that didn't do it.


Thanks

 

[JazzSP8]

Try Application.EnableEvents = False

Just remember to put them back on when you're done