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


  • 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
  • Pls see Mike Glen's post in the following thread:

    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  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
  • 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 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 :-)


    Tuesday, January 8, 2019 12:14 AM