none
How could I import national holidays from Excel or txt file to MSProject 2010 into a new calendar? Thx

    Question

  • I've listed national holidays of several countries (multi-site/transnational project) using the following method: "Export holidays from your Outlook 2007 Calendar to an Excel worksheet"

    Then, I would like to import the national holidays into a new calendar (one per country).

    Any idea?

    Thank you for your support. BR, Mo

    Friday, December 28, 2018 3:53 PM

All replies

  • Hi Moooooooooo,

    there are no tools that I know of that do this.  


    Ben Howard [MVP] | web | blog | book | downloads | P2O

    Friday, December 28, 2018 8:37 PM
    Moderator
  • Pls see Mike Glen's post in the following thread: https://www.mpug.com/forums/topic/handling-multiple-country-holiday-schedules-2/

    The links have been removed but you can make a search on the internet for the tool mentioned there.

    Pls post feedback on your progress.


    Ismet Kocaman | eBooks on Formulas

    Saturday, December 29, 2018 1:00 AM
  • Hi Ismet,

    Thanks for this, I didn't know anything about it. The link is http://www.thoughtcroft.com/downloads/project-holiday-import-wizard.  Alas it doesn't work with anything beyond version 2010.


    Ben Howard [MVP] | web | blog | book | downloads | P2O

    Saturday, December 29, 2018 5:35 PM
    Moderator
  • Hello Ben,

    You're welcome, but I am afraid, I haven't used/tested it yet. 

    It is also included in the Companion Products section here at http://project.mvps.org/comprods.htm. I guess John no longer updates these pages. 

    Happy new year...



    Ismet Kocaman | eBooks on Formulas

    Saturday, December 29, 2018 11:18 PM
  • mooooooooo...

    Yes this can be done but it requires some VBA. I have a macro that exports calendar exceptions from Project to Excel but you need one that goes the other way. I could write a macro for you, but it would take a few weeks (I got a broken "wing"). If you can wait, we can start a dialogue and I can work on as I am able. If not, but you have some VBA experience working between applications, i can probably dig up some code to get you started.

    Of course for a "one-shot" process, you can always do it manually :-)

    John

    Tuesday, January 8, 2019 12:14 AM