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

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?
 
C

Chip Pearson

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
 
C

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking MS Project Data into Excel Worksheet 3
Microsoft Project Export to Excel 4
export Exel task list into Project 2002? 1
Export excel to ACT 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Exporting Data From Excel to SQL 1
export of data from SAP to MS-Excel 2007 1
Export and Save Only Certain Rows of Data 1

Top