Automatically Indent with imported data

[Niel]

Hi

I have imported data from an MS Access Database. One of the fields is the
Quote Number. I would like to automatically create a kind of header
(probably just a new task) for each of the quote numbers and then indent all
of the matching quote numbers under it's "header".

Each time i import the data i want MS Project to automatically do this for me.

Is this possible with VBA coding or macros?

I hope you can help.

Kind Regards,
Niel Vermaas

 

[Jan De Messemaeker]

Hi,

Yes it is.
Use methods such as Activeproject.tasks.add, Application.indent (which
indents the activeselection or Task.Indent to indent a tesk

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Niel]

Thank you very much for the Reply...

Now my only problem is to identify where each quote number changes from one
to another and a method for then automatically setting the new task to the
name of the new quote number.

Any ideas how this could be accomplished?

Thank you in advance,

Niel Vermaas

 

[Jan De Messemaeker]

Hi Niel,

You haven't looked up the methods I talked about, did you?
You would have seen that the tasks.add method implies giving the name.

I do hope your tasks are in quote number order, then use for each task... to
run through the tasks, compare quote number to the previous one, if
differe,nt add, store quote number for the next comparison.

Nothing to do with Project ... it was the very first programming exercice i
got when joining IBM in 1970

Greetings,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Niel]

Thanx alot!

Im working on it now and it seems like its working sofar.

I'll put up another post if i struggle again!

Thanx again for all the help

Regards
Niel Vermaas