Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to export excel data into MS project?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to export excel data into MS project?
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 "soccer75" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to export excel data into MS project?
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 "Chip Pearson" wrote in message ... 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 "soccer75" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Export Excel data to Lotus Notes 6.5 Address Book | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How do I import data from Microsoft Project 2003 to Excel? | Excel Discussion (Misc queries) |