Converting from Project to an Access Database (Project 2000)

[GARYPSWANSON]

In access, I am launching an MS Project Project via a browse feature and then want to convert the open MS Project Project to an Access Database. The code I am using is shown below. I am having a problem with the prjapp.FileSaveAs Name, , , , , , , , , MSProject.mdb8

What is the correct code to do this?

Dim prjapp As MSProject.Application
Dim prjProject As MSProject.Project

Name = "C:MSP"
N = Forms!frmExplorer!lbxFiles.Value
P = stPath & "" & N

Set prjapp = CreateObject("Msproject.Application")
prjapp.Fileopen P
prjapp.Visible = True
prjapp.FileSaveAs Name, , , , , , , , , MSProject.mdb8
prjapp.FileCloseAll
prjapp.FileExit

[GARYPSWANSON]

The following works:

prjapp.FileSaveAs Name:="<C:zzztest.mdb>zzztest", FormatID:="MSProject.MDB8"

[WebGenii]

Thanks for the followup on what worked - I am new to Project VBA, but was watching the thread with interest.

Cheers