• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 830
  • Last Modified:

Excel and Project resource Calendars

Howdy experts,

So here's my question. I have a resource list in Excel, with 40 people on it.  This spreadsheet also doubles at a calendar of availability for the month. (each column corresponds to a day of the month) and the contents of each cell represents his/her availability (a letter in each cell corresponding to a legend).

I have imported the names of the resources, however, I cannot seem to find a way to convert the excel calendar into each individuals availability calendar in Project.  Is there an automated way to do this or would i have to use a Macro or programming in VBA?  

Hopefully there is a way to do this without VBA code.  Any suggestions out there?


2 Solutions
hi Nick,

There is no way to do it other than to write VBA code.

For each resource you enter, Project creates individual resource calendars based on the settings in the Standard calendar. You can modify those calendars on the Working Time tab of the Resource Information dialog box. You can also create and assign resource calendars for individual resources or resource groups to indicate specific working hours; for example, you can assign a resource to the swing shift or night shift. You can edit resources' calendars to indicate nonworking time, such as vacations and leaves of absence.



Hi Nick,

There is'n  other way haw to edit resource calendar, but there iannother aproach can track non working time in administrative projects.

+ you can use PDS to enter information about non working time.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now