Using FileSave

C

CraigO

We used to use FileSaveAs method in MSP 2003 VBA to save the active project
to project server under a given name, and it required the following syntax,
quoted from 2003 help:

In Microsoft Office Project Professional 2003, you must add "<>\" and
include a version for the Name argument when saving to the enterprise. For
example, to save a file to Project Server from Microsoft Office Project
Professional 2003, use the following syntax:

FileSaveAs Name:="<>\FileName.Published"

In MSP 2007, this no longer works this way, we get an error saying that the
file name is invalid and cannot contain certain characters, including < > /
and .

Does anyone know how we can change our VBA in 2007 to accomplish the same
thing? The VBA help in MSP 2007 seems to not be up to par in a lot of areas.
 
R

Ray McCoppin

The macro line:
FileSaveAs Name:=â€<>\My Testâ€

Works fine, adding the .publish gives the error you have stated. Versions
are no longer part of 2007. Replacing the period with as underscore will
also work (migration utility does this). I suggest removing the “.publishedâ€.

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top