Has anyone created a script to import tasks from Excel and update the task in
project? Currently I use a macro to export the tasks due to excel, the users
will update the spreadsheet and I then manually update project 2003. I'd
like to know if VBA can be used to automate this and what things to look for
in automating this.
Unforutnately we are not implementing Project Server, since it would solve
the problem. I appreciate the help.

It is easy enough to do. However you need to export the Task and Resource
Unique IDs so it is easy to find the correct Tasks etc.

If a Task's Unique ID is in a variable called UID, then select a task with

dim Tsk as Task
set Tsk=activeproject.tasks.UniqueID(UID)

now you can update the task.
--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------


"Mary" <Mary@discussions.microsoft.com> wrote in message
news:1FD85ABE-F18F-4367-B393-4DD7C52A2B9E@microsoft.com...
> Has anyone created a script to import tasks from Excel and update the task
> in
> project? Currently I use a macro to export the tasks due to excel, the
> users
> will update the spreadsheet and I then manually update project 2003. I'd
> like to know if VBA can be used to automate this and what things to look
> for
> in automating this.
> Unforutnately we are not implementing Project Server, since it would solve
> the problem. I appreciate the help.

Thanks!

"Rod Gill" wrote:

> It is easy enough to do. However you need to export the Task and Resource
> Unique IDs so it is easy to find the correct Tasks etc.
>
> If a Task's Unique ID is in a variable called UID, then select a task with
>
> dim Tsk as Task
> set Tsk=activeproject.tasks.UniqueID(UID)
>
> now you can update the task.
> --
>
> Rod Gill
> Project MVP
>
> Project VBA Book, for details visit:
> http://www.projectvbabook.com
>
> NEW!! Web based VBA training course delivered by me. For details visit:
> http://projectservertraining.com/learning/index.aspx
>
>
> ----------------------------------------------------------------------------------------------------
>
>
> "Mary" <Mary@discussions.microsoft.com> wrote in message
> news:1FD85ABE-F18F-4367-B393-4DD7C52A2B9E@microsoft.com...
> > Has anyone created a script to import tasks from Excel and update the task
> > in
> > project? Currently I use a macro to export the tasks due to excel, the
> > users
> > will update the spreadsheet and I then manually update project 2003. I'd
> > like to know if VBA can be used to automate this and what things to look
> > for
> > in automating this.
> > Unforutnately we are not implementing Project Server, since it would solve
> > the problem. I appreciate the help.
>
>
>