I have macros which open and close files in order to process data.

I have to manually respond to file prompt boxes which I would like to bypass. I used to be able to switch off the prompts in old style 123 macros. I was wondering if there is the same facility within Excel.

The specifics are:

On opening a file I get the "This workbook contains links to other data sources" prompt. Answer is always "Don't Update"

On closing a file I get the "Do you want to save the changes" prompt. Answer is always "No".

On replacing a file which already exists with "Save As" I get the "Do you want to replace it?" prompt. The answer is always "Yes"

Even if I can't bypass the prompts, if I could 'seed' the prompt with the appropriate response this would help.