Copy Outlook calendar to Excel - need help please.

amdon11

New member
Joined
Jul 31, 2013
Messages
7
Reaction score
0
Points
0
A few months ago I visited VBA programming forum looking for a way to copy a shared calendar from Outlook into Excel. I found a topic titled Copy Outlook Calendar to Excel, dated 2012-02-24 which Ken Puls responded to with a spreadsheet for Excel. I downloaded the calendar.xlsm spreadsheet (View attachment calendar.xlsm)

- it worked fantastically but now...

When I open it and place a date range i.e. July 1 thru July 31 it is not downloading all of the calendar entries - it is downloading only July 1st and July 31st - before it would give me the all of the entries for July.

I'm confused because I do not know what happened. Can someone help me because I am the assistant to a lot people and it was great to be able to open this spreadsheet, get all of the calendar entries instead of having to sit at each one of their desks to use the export function in Outlook.

Thanks!
 

royUK

New member
Joined
Mar 22, 2011
Messages
155
Reaction score
0
Points
0
Location
Derbyshire, UK
Website
www.excel-it.com
Excel Version(s)
most versions
Please don't keep starting new threads on the same problem. Bump the original by posting to it with something like "I still need help"
 
Top