How do I automatically select 'Append' for saving?

[Dustin Ventin]

I am using VBA/Macros to allow users to save their Project files as MDB
databases. However, when I run the macro, it comes up with the screen asking
if the user wants to append or overwrite.

Now, if the user were to press 'overwrite', they would destroy all the
information already in the table- and I don't want that possibility. Is
there any function or workaround that makes the saveas fuction automatically
overwrite?

Thanks!

Dustin

 

[Rod Gill]

Hi,

I think you have got into an export method rather than a save. Save always
re-writes the entire project to the database.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Rod Gill]

Hi,

Record a macro of you saving to the database manually then use that code
instead. See if that works for you.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/