how to saveas project file to access db

[fenglei]

Hi

I try to saveas project file to access db.
At VBA help, there have a filesaveas method, and set format string
arguement to "MSProject.mdb".
But in my code, it always fail.
my code is:

ThisProject.Application.FileSaveAs "aaaa.mdb", , , , , , , , ,
"MSProject.mdb"

error is:

Run-time error '1101':
The argument value is not valid.


I try other format, all can work. only saveas to access db fail.

anybody know this?

Thanks for any help
Fenglei

 

[Jerry Dingle]

Would you please e-mail the answer at (e-mail address removed)

 

[Rod Gill]

Record a macro of you saving manually. That will record all the code you
need.

 

[fenglei]

Thank you Rod.
After record Macro, I find the formatID is "MSProject.mdb8" instead of
"MSProject.mdb" at MSDN Help.
Do not know why there have a wrong help file at MSDN.

Fenglei

 

[Neowile]

Hi,

I have an error message ("Invalid Argument") with

FileSaveAs("essai.mdb",0,1,0,0,0,"","","","MSProject.MDB8")

I use Office 2003

Can you help me please

 

[JB]

Don't enter blank strings for the null values (Table, UserId and
DataBasePassword)

Ex: FileSaveAs("essai.mdb",0, 1, 0, 0, 0, , , , "MSProject.MDB8"