CODEWITHSUNDEEP
vbams-projectms-project-server-2013
Jack Flint
Jack Flint

Reputation: 21

Project Server 2013 File Save Without Prompt

I’m trying to save a file that I previously opened on Project Server 2013. The only updates I’ve made to the files is to set the status date and move unfinished tasks. I’m running the file in excel VBA. I can share the complete set of code but I do not think it is necessary. If I run the macro without saving the files everything runs perfectly. All I need to do is get the files to save without prompting me and I’m done. All help is appreciated.

Dim appPJ As MSProject.application

Set appPJ = New MSProject.application

appPJ.FileOpenEx Name:="<>\" & strFileName, ReadOnly:=False, Noauto:=True, IgnoreReadOnlyRecommended:=True, DoNotLoadFromEnterprise:=False

'Update the status date and move unfinished tasks to the future

appPJ.ProjectSummaryInfo StatusDate:=dateStatusDate

appPJ.UpdateProject All:=True, UpdateDate:=dateStatusDate, Action:=2

'Call the various read data only report routines

appPJ.DisplayAlerts = False

appPJ.FileCloseEx pjSave, True, True

The line above will not save to server with a prompt.

Upvotes: 1

Views: 464

Answers (0)

Related Questions