none
Import from Excel Holydays and non working time RRS feed

  • Question

  • Hi,

    I would like to import holydays, non working time and Service Operation from an excel file to MSProject. I'm not a VBA spcialist. I found the opposite operation (Export) but not the import.

    Has someone have a piece of code for that?

    Thanks

    CORGAE

    Friday, October 5, 2018 12:19 PM

Answers

  • Hi John and Gael,

    I just sent you over the VBA macro. I wanted to package it and post it on the technet gallery but since I'm not a VBA expert, I didn't want to propose something not in the state of the VA art...

    Note that it does not cover unit/availability with effective dates, just the exceptions.

    Below if needed 2 useful links if you want to enrich the macro with units by effective dates.

    • https://www.tek-tips.com/viewthread.cfm?qid=1498428
    • https://social.technet.microsoft.com/Forums/windowsserver/en-US/e90f7f10-fdc8-4d74-a1d5-0a570332554c/resource-availability-and-vba?forum=project2010custprog

    @John, I think the post you were refering to about Gérard's request is the 2nd one, on the resource availability.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Monday, October 8, 2018 10:17 AM
    Moderator

All replies

  • CORGAE_1,

    I don't have any code that does what you want but let me ask you a question. Is this something you need to do on a regular basis (e.g. monthly) or is this a one time transfer? Setting up holidays should be a one-time operation but the other non-working time and "service operation", (whatever that is), may change or need to be updated more than once. If the transfer of data is infrequent (e.g. once a year), then doing it manually may be a better option. However if you need to transfer the data on a regular basis (e.g. monthly), then a macro would be appropriate.

    You mentioned you found some code to transfer the information from Project to Excel. If I may ask, where did you find that?

    John

    Friday, October 5, 2018 1:52 PM
  • I think once Gérard (Ducouret) gave me a VBA macro to add exceptions to resources from a simple excel file (resource UID, name, start date, finish date, exception name).

    If you're interested, contact me through LinkedIn. 

    @John, I'll be glad to send it over to you!


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Friday, October 5, 2018 2:39 PM
    Moderator
  • Guillaume,

    Interesting. About a month ago Gerard posted a couple questions on the Project customization & programming forum asking for VBA code for resource calendar exceptions. I responded to one post and Barbara responded to the other. So yes, I'd like to get a copy of the macro you have.

    John

    Friday, October 5, 2018 3:51 PM
  • Hi John,

    I need to do this operation on a regular basis, we are using Microsoft AX to manage holydays, services in operation (out of this office) and timesheet.

    So we would like to use AX as datasource and import ressource allocation into MSProject one per month.

    The code to export from MS project to excel can be found here: msproject-kk.blogsport.com

    Thanks for your support.

    Monday, October 8, 2018 8:08 AM
  • Hi Guillaume (Bonjour!)

    I send you an invitation on Linkedin. Hope you will be able to help me.

    Monday, October 8, 2018 8:12 AM
  • Hi John and Gael,

    I just sent you over the VBA macro. I wanted to package it and post it on the technet gallery but since I'm not a VBA expert, I didn't want to propose something not in the state of the VA art...

    Note that it does not cover unit/availability with effective dates, just the exceptions.

    Below if needed 2 useful links if you want to enrich the macro with units by effective dates.

    • https://www.tek-tips.com/viewthread.cfm?qid=1498428
    • https://social.technet.microsoft.com/Forums/windowsserver/en-US/e90f7f10-fdc8-4d74-a1d5-0a570332554c/resource-availability-and-vba?forum=project2010custprog

    @John, I think the post you were refering to about Gérard's request is the 2nd one, on the resource availability.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Monday, October 8, 2018 10:17 AM
    Moderator