#1
|
|||
|
|||
Export Data from Ms project to Ms access using VBA
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks for the link JulieS.
V |
#4
|
|||
|
|||
You're welcome, V.
|
#5
|
|||
|
|||
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.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Export data from multiple attachments into a single excel document | Woolstar | Outlook | 0 | 12-07-2011 09:49 AM |
Help finding starting point on project (Excel/Access?) | ndk415 | Office | 1 | 06-19-2011 03:28 AM |
Access project installation | george.bobos | Project | 0 | 01-14-2011 03:45 AM |
Transfering Project into Access | hb367 | Project | 0 | 09-07-2010 11:09 AM |
Create a Custome Form and export data to Access | ashleybyrdnc | Office | 0 | 03-05-2010 09:41 AM |