Pass a command to a msg box and ignore user input (1 Viewer)

[virencm]

Hi

I have got the export process from Project to Access working quit well. I have a macro that automates this function
when i run this export macro it asks me , whether i want to "Append" or "Overwrite "the Data. is there some code that can get rid of this msg box and automatically choose overwrite?

I want to schedule this as an early morning job but cant because it stops at this msgbox.

Any help is greatly appreciated

V