Forum Discussion

Per_Alm's avatar
Per_Alm
Copper Contributor
Jan 18, 2023

Downloading and importing international calendars?

Hi, in a video lecture I heard it mentioned that it should be possible to download and import calendars to Project. When working with team members from different countries it would be convenient to download calendars adapted for each country. However, I can not find anything about this when googling.

 

Someone who knows?

 

Best, Per Alm

Sweden

  • Per-Alm --

    If the country calendars were created in Microsoft Project, then you can definitely import them. If they were created in any other application, such as Microsoft Excel, then you cannot import them.

    To import a calendar in Microsoft Project, do the following:

    1. Ask the user to send you a Microsoft Project file that contains the country calendar.
    2. Open the project containing the country calendar.
    3. Click File > Info > Organizer.
    4. In the Organizer dialog, click the Calendars tab.
    5. Select the country calendar on the RIGHT SIDE of the dialog (in the project you received) and then click the Copy button to copy the calendar to the LEFT SIDE of the dialog (to your Global.mpt file).
    6. Click the Close button and then exit the Backstage.
    7. Close the project and then exit Microsoft Project completely.

    When the custom country calendars are saved in your Global.mpt file, they will be available for your use every time you launch Microsoft Project. Hope this helps.
  • John-project's avatar
    John-project
    Silver Contributor

    Per_Alm,
    i don't know of any way to import a calendar, at least not into the desktop version of Project. In the video lecture, did it provide any details or what version of Project could do the import?

    It is possible to "import" calendar information from another application (e.g. Excel) using VBA. It might also be possible to import calendar information from Outlook using VBA.

     

    Maybe my colleagues are aware of other possibilities and will check in with their suggestions.

    John

    • Per_Alm's avatar
      Per_Alm
      Copper Contributor
      Thanks John. It is in this video from Learnit Training, at the time 1:22:50. Here is a link starting at that time: https://youtu.be/OuOZVoTwqm8?t=4968 Overall, an excellent video. He says: "You can download calendars and make those part of your global template. You learn how later on." However, I can not find it mentioned again, neither in this video for beginners or the following advanced video: https://youtu.be/1vzGD6igNSA The lecturer is David Lieberman, now at gravitylearning.com. Maybe I'll try to contact him.
      • Per-Alm --

        If the country calendars were created in Microsoft Project, then you can definitely import them. If they were created in any other application, such as Microsoft Excel, then you cannot import them.

        To import a calendar in Microsoft Project, do the following:

        1. Ask the user to send you a Microsoft Project file that contains the country calendar.
        2. Open the project containing the country calendar.
        3. Click File > Info > Organizer.
        4. In the Organizer dialog, click the Calendars tab.
        5. Select the country calendar on the RIGHT SIDE of the dialog (in the project you received) and then click the Copy button to copy the calendar to the LEFT SIDE of the dialog (to your Global.mpt file).
        6. Click the Close button and then exit the Backstage.
        7. Close the project and then exit Microsoft Project completely.

        When the custom country calendars are saved in your Global.mpt file, they will be available for your use every time you launch Microsoft Project. Hope this helps.
  • Diana__Roy's avatar
    Diana__Roy
    Copper Contributor

    Per_Alm 

    Sure thing! Absolutely, adding country-specific calendars to Project can be a game-changer for international collaborations. Although it's not a one-click process, try searching for downloadable calendar files in .ics format online. Importing them into Project may need a bit of a workaround, but Microsoft's support team can give you a step-by-step guide. Cheers to seamless project planning across borders! 🌐:spiral_calendar:️

Resources