Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • Last Modified:

How to export a shared calender to CSV file

I have a shared calendar that a group uses and they need t exported to a CSV file. But when I start my outlook and open the shared calendar to export, export only shows my calendar that can be exported.

Is there a way to export the shared calendar?

running outlook 2013 and 2007
0
rdefino
Asked:
rdefino
  • 6
  • 5
1 Solution
 
regmigrantCommented:
The export functions in Outlook are fairly limited but the owner of the shared calendar (the person who set it up) should have no problem doing the export.

Alternatively - and much more flexible - you can use VBA as found in the My Outlook Calendar Template from Microsoft. This was originally distributed with Word 97 but works quite well today.

It has been greatly improved and modified by Michael Saye and his site is here:-
http://www.slipstick.com/outlook/calendar/idiots-guide-amending-outlook-calendar-template/

As defined it will use a word template to extract any calendar you have access to and display it in a nicely formatted word document.

If the CSV output is a requirement beyond this then let me have the following information and I can add a module to use Michael's code and put a CSV file out at the same time.

1. is weekly/monthly enough or do they want to choose a range of dates?
2. do they need to choose filenames or can I use a default path and name?
3. what level of detail is needed in the CSV (eg: start end time, subject, location, attendees, reminders, recurrence, all day events, etc etc)
0
 
rdefinoAuthor Commented:
Let's go for Jan - March 2014 and I need all events (all day or start & end time).  I don't believe the events have location or attendees so you can skip that part.  Mon - Sun - just in case.

Any filename

Thanks
0
 
regmigrantCommented:
Take a look at the attached macro enabled template - double clicking should start a new document and show a form (you may need to enable content).
Choose the calendar, start month and number of months to report

I've kept it simple to see if it's close to what you need - let me know what changes you might like to see

- it will create MyOlCal.csv on the desktop, overwriting any existing copy without warning
- it outputs start date/time, end date/time and subject only
- it uses US date format (mm/dd)
- it only works with the monthly calendars
- there are (existing) bugs in the template which mean you must select banners and print weekends - it makes no difference to the csv file

note that the majority of this code is copyright Michael Saye as noted above and in the code
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
rdefinoAuthor Commented:
cool , thanks.

One question, I don't see any attached file. :)

also, where do I open this file from? Outlook, word?
0
 
regmigrantCommented:
Apologies, EE wouldn't accept a .dotm file

Its a Word template, double click to start
OL-calendar-EE--2-.dot
0
 
rdefinoAuthor Commented:
So I got an error, attached it.

I;m using word/outlook 2013 32bit.

I opened the shared calendar and made that the only one selected, ran the macro and got the error.
worderror.PNG
0
 
regmigrantCommented:
I can only get that error to appear if I do not have a calendar folder open in Outlook or outlook is closed and I ask for 'currently selected calendar'.

try it with an un-shared calendar first - the dialog box will show the current user's calendar at the top of the list, if that works then we can look at the shared one
0
 
rdefinoAuthor Commented:
I tried it against my own calendar and I get this error, attach files.
error1.PNG
error2.PNG
0
 
regmigrantCommented:
OK, that's a problem with creating the output file. I can't fix at the moment but will look at it later.

If you know any VBA at all you can check the following:-
Run it again and hit debug when the error appears then in the immediate window:-

type
debug.print cOutFile
it should show a filename with a path that points to your desktop
0
 
regmigrantCommented:
I used a standard method of finding and appropriate directory (the desktop) and creating the output file - did a CSV file appear on the desktop (it will be empty)?

To save messing about if you can give me the full path of where you want the output to appear I'll just incorporate that
0
 
rdefinoAuthor Commented:
Thanks!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now