Exporting MS Project to Access using VBA

[lmontes]

I'm trying to write a macro to save the MS Project to an access database. The users have the option to enter the file name and location. I have designed a map called Export Resources.

This is what I have now:

SaveFileName = InputBox$("Enter Path and file to save project to: ")
FileSaveAs Name:=SaveFileName, FormatID:="MSProject.mdb8", map:="Export Resources"

When I run this, I get a runtime error: The argument value is not valid.

When I try the exact same thing to save to Excel, it works.

Any ideas?

 

[PDQBach]

What happens when you change FormatID:="MSProject.mdb8" to FormatID:="MSProject.mdb"

 

[lmontes]

I finally figured it out.

I had to include the <> around the file name..
Thanks for trying to help!

 

[PDQBach]

Please share the entire correctly coded statement. Thanks.

 

[lmontes]

Here you go:

SaveFileName = "<" & InputBox$("Enter Path and file to save project to: ") & ">"

FileSaveAs Name:=SaveFileName, FormatID:="MSProject.mdb8", map:="Export Resources