MS Project 2003 - Resource Calendars

S

S.M.Davies

Is it possible to import data into a MS Project Resource Calender to update
leave time and sick time , etc ?
 
H

Horus

Hi,
There is no direct way to this. When I say direct, I mean a way that is
supported by Microsoft. The PDS don't allow access to this feature. What
I did, is to write directly into the database, and it works like a
charm.
 
S

S.M.Davies

Thanks for the feed back, but I am not that familiar with the DB structure
and would like some direction on how to do this if possible ?
 
S

S.M.Davies

Since the update from "Hours" I was able to investigate further and created a
macro to allow the updating of resource non-working days. This is currently a
3 step process - Refresh my source data in Excel (coming from and SQL over
corp. directory), import this into Project as a task list, process the task
list with new macro to update each resources non-working time. This is more
than effective and will save many hours of manual loading of this data.

Issue Resolved - Thanks Sean Davies
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top