Importing hierarchy into excel

[Alice818]

I want to be able to automatically import my hierarchy in excel into project.
So far I've been manually indenting things once I've imported my excel
information.

This is the setup of my excel file:
Parent | Subtask | Date

in project it should look like this
parent1
subtask1
subtask2
subtask3
parent2

Thanks in advance.

 

[Mike Glen]

Hi Alice,

Welcome to this Microsoft Project newsgroup

See in Jack's site:
http://masamiki.com/project/export-hierarchy-to-excel.html

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

 

[Alice818]

Hi Mike,

That was a great site! Thanks. I'm starting to learn macros.

Alice

 

[Alice818]

Jack's site seems to show how to export hierarchy to excel. Is this something
I can modify so a hierarchy is imported into Project? I have never done any
Visual Basic programming. Where's a good place to learn how to start?

Thanks,
Alice

 

[Mike Glen]

You're welcome, Alice

At the bottom of the page here: http://project.mvps.org/links.htm, there's a
refernce to Project 98 vba training materials which, I understand, are just
as relevant to the later versions of Project. You might also like to try
posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
MS Project MVP

 

[Martin Wilkinson]

I've imported hierarchy into Project using the OutlineLevel field. If the
Excel sheet is like this:

Name OutlineLevel
a 1
b 2
c 1

It will import (using an import map) as:

a
b (subtask of a)
c

Don't know if your Excel file can be manipulated to this format first or not.

Martin