I've written an AutoExec macro that works fine, running a series of queries. However, when it comes to an Output command to an existing report that I want to replace, the prompt "The file already exists. Do you want to replace the existing file" stops the macro from continuing until I answer the question Yes. I've searched ExpertsExchange for a similar question, and tried creating a Global Function which I include as one of my first macro steps. The function is ActionQueryConfirmation(Fa
lse). This doesn't work, I'm still prompted "Do you want to replace the existing file Yes/No". I'm wanting to run this macro every morning, creating 3 new reports for the users to have available first thing.
Public Function ActionQueryConfirmation(NewValue As Boolean)
Application.SetOption "Confirm Action Queries", NewValue