Macro from excel 2007 doesn't work in excel 2010

[maddozs]

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.

[OllieB]

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.

[maddozs]

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

[OllieB]

You may want to check:

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

[maddozs]

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