MsgBox Loop

[lilanngel]

Hi! I'm looping through hundreds of excel workbooks using a loop macro. Unfortunately, each file starts with a MsgBox (with Y/N) that says "This file is confidential, are you sure you want to continue?"

What code can I use to make it say "Yes" automatically?

I've tried:

Application.DisplayAlerts = False

but that didn't work (the MsgBox still popped up).

I've also tried:

SendKeys "y"

but that didn't work either - MsgBox still popped up.

Please help! Thank you!!