Page 1 of 1

export data

Posted: Tue Jan 01, 2013 9:37 am
by Elwell
I would like to export calendar events into a word doc agenda

Re: export data

Posted: Tue Jan 01, 2013 11:31 am
by aebrown
About the best I've been able to come up with is to do the following:
  • Sign in to the Calendar on LDS.org
  • Go to Agenda view
  • Select the entire contents of the view (from the first day through the last day of the month)
  • In a word processor, use paste special to paste just the text
  • Do some Search & Replace operations to eliminate the image filenames that got pasted (or in some cases you may want to replace an image such as allDayEvent.png with some text that indicates it's an all-day event)
  • Since there's no space between the day of the week and the month name, replace something like "dayJan" with "day, Jan" (for January, of course)
  • All the S&R operations can be automated in a macro if you're going to be doing this often.