+ Reply to Thread
Results 1 to 3 of 3

Excel/Outlook 2007 vba code doesn't work in Excel/Outlook 2010

  1. #1
    Registered User
    Join Date
    06-18-2014
    Location
    sydney
    MS-Off Ver
    2010
    Posts
    8

    Excel/Outlook 2007 vba code doesn't work in Excel/Outlook 2010

    Hi all,

    My company recently upgraded everyone to Microsoft 2010 from 2007 version. I have no substantial VBA skill and left with a VBA code which is supposed to extract a list of outlook emails sitting in a shared mailbox into Excel. I was using that VBA code in Outlook 2007 and it worked fine but shows the following error when run in Outlook 2010: 'Run-time error '-2147221233 (8004010f)': The attempted operation failed. An object could not be found. Here is part of the code:

    Please Login or Register  to view this content.
    It worked after one of the members suggested to "click on any line of this code and press F8 repeatedly until the yellow focus moves to the error line, don't press F8 anymore. Now in immediate window, copy paste each of below lines, press enter after each line. Let us know where the error occur." However, it stop working the next day. Any help would be greatly appreciated. Thanks! - Evelyn
    ? olNS.Folders("Mailbox - Market Intelligence").Folders.Count
    ? olNS.Folders("Mailbox - Market Intelligence").Folders("Inbox").Items.Count
    ? olNS.Folders("Mailbox - Market Intelligence").Folders("Inbox").Folders("MI").Items.Count

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Excel/Outlook 2007 vba code doesn't work in Excel/Outlook 2010

    You might check your references. In the VBA window, select Tools - References. In 2010, it should look something like this:

    References.PNG.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  3. #3
    Registered User
    Join Date
    06-18-2014
    Location
    sydney
    MS-Off Ver
    2010
    Posts
    8

    Re: Excel/Outlook 2007 vba code doesn't work in Excel/Outlook 2010

    Hi, I have already ticked all the suggested boxes and it still doesn't work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel/Outlook 2007 vba code doesn't work in Excel/Outlook 2010
    By eveloy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-19-2014, 07:44 PM
  2. [SOLVED] VBA Macro to print to Pdf format and place as attachment in Outlook (Excel & Outlook 2007)
    By Webman1012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 01:25 PM
  3. Macro from excel 2007 doesn't work in excel 2010
    By maddozs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2013, 04:57 AM
  4. Replies: 2
    Last Post: 11-12-2012, 04:41 PM
  5. Share Task From Outlook 2010 to Outlook 2007 and Vice Versa
    By Hudas in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 10-22-2012, 03:01 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1