open .mpp out of excel

[colty]

Hi,

I want to open an existing MSProject file out of an excel macro?? Can somebody help me?

Regards

 

[PHV]

Have you tried the GetObject function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[colty]

Yes i used this, but i get an error

Set pjApp = GetObject("Croject.mpp", "MSProject.application")

 

[Annelies]

Hi

Try this...

Dim strFileName As String
Dim objProject As Object

Set objProject = CreateObject("MSProject.Application")
strFileName = Application.GetOpenFilename("MS Project (*.mpp),*.mpp", , "Select MS Project File to import from")
objProject.FileOpen Name:=strFileName, NoAuto:=True

'Do whatever you want to with it

objProject.FileClose 0  '0 = Do Not Save File
Set objProject = Nothing

I hope this helps/makes sense!

Annelies