A small macro question

Member for

20 years 3 months
Permalink

Set ProjAppl = CreateObject("MSProject.Application")

Title = "Please Select Microsoft Project File"
fname = Application.GetOpenFilename("Microsoft Project Files (*.mpp), *.mpp", , Title)

ProjAppl.FileOpen fname, ReadOnly:=False, FormatID:="MSProject.MPP"
Set aProj = ProjAppl.ActiveProject

’now open a seccond project
Title = "Please Select Microsoft Project File"
fname = Application.GetOpenFilename("Microsoft Project Files (*.mpp), *.mpp", , Title)

ProjAppl.FileOpen fname, ReadOnly:=False, FormatID:="MSProject.MPP"

Set bProj = ProjAppl.ActiveProject

Now you habe aProj.xxx
and bProj.xxx