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

Answer 1

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