Export to MS Project

[Cathy]

Hi,
I am trying to create VB code in excel that will

1. open a specific ms project file
2. select a range of excel data
3. update the ms project file
4. save and close the ms project file
5. return to excel

Thank you for any help you can provide

Cathy

 

[Dick Kusleika]

Cathy

You'll have to be more specific about numbers 2 and 3. Here's how you do
numbers 1, 4, and 5.

Sub DoProject()

Dim prApp As MSProject.Application
Dim prProj As MSProject.Project

Set prApp = New MSProject.Application
prApp.FileOpen "\\Pm1\c\WINDOWS\Desktop\Job Schedules\MtCalvary.mpp"
Set prProj = prApp.ActiveProject

'Do numbers 2 and 3

prApp.FileSave
prApp.Quit

End Sub

Set a reference (VBE - Tools - References) to the MS Project Library.