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

Hi V,

Sorry, I'm not a VBA expert -- I suggest re-posting your question (including Project version) to the Microsoft Forum focused on Project Customization. See:

http://social.technet.microsoft.com/...stprog/threads

Thanks for the link JulieS.
V

You're welcome, V.

The full options on this should come up in the vba editor when you type in 'DoCmd.' You should be able to run your macro automatically with appended options.