Save Microsoft Project file from Access?

[Fozzie22]

Hi,

does anyone know how i can save a project in microsoft project from microsoft access using vba? so far i have been able to open MS Project, create a new project and fill it with data from an Access query. Now i want to be able to save the project under a specific name in a specific directory when all the data has been inserted.

I have tryed the save as method used by excel and word but it does not seem to be working, i may just not be doing it right though.

any ideas would be appreciated

thanks

 

[TonyJollans]

Use the (MSProjectApplication).FileSaveAs method.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[