Is there a way to export excel data into MS project?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have developed an excel spreadsheet and I'm looking for a way to export
certain fields of data from excel to MS Project. Is this possible?
 
What do you want to export to project? Tasks? Try code like

Dim Proj As MSProject.Application

Sub AAA()
On Error Resume Next
Set Proj = GetObject(, "MSProject.Application")
If Err.Number <> 0 Then
Set Proj = CreateObject("MSProject.Application")
End If

Proj.ActiveProject.Tasks.Add Name:=Range("A1").Text
End Sub

You will likely get better answers in a Project newsgroup.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I should have added that you'll need a reference in VBA to the
Project library. In VBA, go to the Tools menu, choose References,
and scroll down to Microsoft Project. Check that item in the
list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top