Results 1 to 6 of 6

Thread: Help with Excelguru VBA spreadsheet downloaded that worked but now it doesn't work

  1. #1

    Question Help with Excelguru VBA spreadsheet downloaded that worked but now it doesn't work



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 - 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!

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Provide alink to the original post and/or attach the workbook
    Hope that helps

    Roy

  3. #3
    calendar.xlsm

    Here it is. Thanks

  4. #4
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    as anything been changed in OutLook?
    Hope that helps

    Roy

  5. #5
    An update was done a few weeks ago to add News Gator but I used the spreadsheet after that and it worked fine. Thanks so much for trying to help - I really appreciate it

  6. #6

    Still need help

    I still need help with the the above

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •