Problem Exporting to MDB

[Randy M]

I've written a VB program that attempts to automate the process of doing a
Project File Save As to an Access database. The problem I'm having is that
the output file (.mdb) doesn't show up. There's no indication of an error
anywhere. Obviously I'm doing something wrong, but I haven't been able to
figure out what.

I have an export map that I've developed which has been tested using the
UI's File>SaveAs menu.

The code goes basically like this:
Set msprj = CreateObject("MSProject.Application")
msprj.FileOpen("myProj.mpp")
status = msprj.FileSaveAs( _
Name:="c:\myProj.mdb", _
FormatID:="MSProject.MDB8", _
TaskInformation:=True, _
Filtered:=False, _
Map:="My Export Map")

This call returns a True, presumeably to indicate success, but no joy.

Any ideas for how to track down what's going wrong?

Randy

 

[Ed]

Randy
Try changing your FormatID to "MSProject.mdb". If it still doesn't work, remove the Map parameter and try again

Ed