+ Reply to Thread
Results 1 to 5 of 5

Macro from excel 2007 doesn't work in excel 2010

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    3

    Macro from excel 2007 doesn't work in excel 2010

    Hi, I was wondering if anyone is able to help.

    I recently got a new machine with excel 2010 and was trying to run some marco created with previous version of excel.

    I keep getting the error message" Run-time error '1004': Method StatusBar 'of object'_Application' failed.

    Part of the codes pertaining to the error is as follows (the 2nd line is that one that is highlighted when trying to debug):

    Please Login or Register  to view this content.
    the purpose of the code is to import data into excel and was working without any problem in excel 2007.

    Can anyone help?
    Thanks!!!


    Moderator's Note: Welcome to the forum, thank you for joining. Btw when posting codes be sure to put code tags..Select the codes then hit the "#" symbol. I'll do it for now. Thanks.

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Macro from excel 2007 doesn't work in excel 2010

    I regret to inform you that I am running the code as provided by you in Excel 2010 (after adding the missing 'end if' at the end) and receive no such error message. The selected Excel workbook opens adn the status bar is updated.
    If you like my contribution click the star icon!

  3. #3
    Registered User
    Join Date
    02-21-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Macro from excel 2007 doesn't work in excel 2010

    Thanks. It's there any options in Excel 2010 that I need to turn on before the marco will work?

  4. #4
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Macro from excel 2007 doesn't work in excel 2010

    You may want to check:

    Excel Options (From the File Menu), Trust Center, Trust Center Settings -> lots of settings that may be relevant

  5. #5
    Registered User
    Join Date
    02-21-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Macro from excel 2007 doesn't work in excel 2010

    I checked the settings in the trust centre but nothing seems to work.

    My co-worker has the same problem has the same problem and he just got a new machine like I did. Could it be something pertaing to the setup of the laptop we got?

    Anyone with any ideas

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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