Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Oct 2003
    Location
    Toronto, Ontario, Canada
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up

    I have a VBA program in an Excel wrapper that correlates resource calendar non-working times in a common resource pool with entries in a series of Exchange (Outlook) Public folder calendars and the Global Address List (GAL) and presents the data in a spreadsheet for consumption by individual project resource allocation spreadsheets.
    The section that retrieves the resource pool data loops through the resources, then through the months in the target range (usually a year), then through all the days in that month to test if that is a non-working day. We have about 150 resources and this takes a while. Is there a faster way to work through the data? I could skip weekends, but can't think of anything else. Is there a way of looping through the months/days and then the resources for entries on that day?

    Stu Boasman
    Toronto, Canada

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Reposted in the VB/VBA forum as Post 786627. To prevent confusion and duplication, this topic is closed. Please post replies in the new topic.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •