none
Calendar

    Question

  • Hello

    I have been trying to find a code or create a system that when I create a calendar in Excel(simple columns like name, date start, finish), I can export it to ICS or VCS that way I can import that calendar in Outlook, but I dont find any solution.

    Is it possible?

    Thank you

    JP

    vendredi 11 mai 2012 19:03

Réponses

  • Hello

    I have been trying to find a code or create a system that when I create a calendar in Excel(simple columns like name, date start, finish), I can export it to ICS or VCS that way I can import that calendar in Outlook, but I dont find any solution.

    Is it possible?

    Thank you

    JP


    An internet search site will lead you to any number of useful sites including http://en.wikipedia.org/wiki/ICalendar, which explains the ics format.  You should be able to write vba code that takes your data in whatever form they are organized and creates a ics text file.

    Tushar Mehta (Technology and Operations Consulting)
    www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)
    Microsoft MVP Excel 2000-Present

    samedi 12 mai 2012 04:06