Hi All,
Here's the situation. I have 30+ files which are all exactly the same. I have to make changes to each of these files individually (they are all stored in the same folder). I write simple VBA code to make the necessary changes and this works just fine. Here's the problem..when each file opens, there are two consecutive message boxes, one which asks whether the file is to compare to Forecast or Prior Year and the other requires a Yes or No answer.

How do I write VBA code to answer these automatically when the file opens? Currently I have to manually click on the appropriate button which is repetitive and slows the process.

Any help or useful links would be appreciated.
Thanks
Bozo