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
 

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
how do i export data to an email with excel 2
Exporting Data From Excel to SQL 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
turn off excel cell modifications? 1
export Exel task list into Project 2002? 1
export of data from SAP to MS-Excel 2007 1

Back
Top