Automating Importing Excel Info

[Kevin Flanagan]

What I would like to do is to have a some code that would
read an Excel file and import information as new tasks
under the latest sub task within a group. For example if
POR 589 was the last task entry under POR Support, I
would like it to check for the latest task and insert a
new task under it.

Any help apopreciated,

Thanks,


Kevin

 

[Gérard Ducouret]

Hello Kevin,
If the data are organized in columns in Excel, you can import them via a Map
:
File / Open / File of type : Microsoft Excel workbook (*.xls)
Open / New Map / ...
- Append the dat to the active projet (That what yo need I think)
- Merge the dat into the active project (Needs the setting of a Merge Key
as the Unique ID)
etc...

This data handling can easily be recorded in a VBA procedure with auto
recording.

Hope this help,

Gérard Ducouret

 

[Kevin Flanagan]

Yes, but is there a way to automate it with the code
knowing where in the project plan to place the imported
tasks without having to manually intervene using a map or
macro??

 

[John]

Kevin,
The simple answer is "yes". With VBA you can do virtually anything you
want, limitied only by your VBA experience and ingenuity.

John
P.S. did you perchance used to work for a company in Southern Arizona?

 

[Gérard Ducouret]

With VBA procedures you can do almost everything you want. But you need to
specify exactly what you want.

Gérard Ducouret

"Kevin Flanagan" <[email protected]> a écrit dans le
message de [email protected]...
Yes, but is there a way to automate it with the code
knowing where in the project plan to place the imported
tasks without having to manually intervene using a map or
macro??