VBA To Select Yes on Prompt Box

[Gian624]

Hi Everyone,

I'm writing some code to open files in a loop, run a macro and select "Yes" on the prompt box that opens iimmediately after the macro is ran. I'm having trouble automatically selecting yes to continue running the macro. Any ideas?

Thanks All,
Matt

 

[chantyclause]

Thanks for your help everyone, I developed a solution.

I know it's 8 years later, but if you're still around, can you share the solution? I'm running into this exact problem. Luckily it's only 3 worksheets instead of 54!