New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

2007 macro showing error in 2010

Macros, VBA, Excel Automation, etc.

2007 macro showing error in 2010

Postby jpk0920 » Wed Dec 14, 2011 4:11 am

Hello,

I have a macro which is written in 2007 Excal VBA. it is working fine in 2007 excel VBA. But when i'm trying to run same macro in 2010 Excel VBA showing a error.

Error:

Run-time error '-2147417848 (80010108)

Automation error
The object invoked has disconnected from clients.

Thanks & Regards
Pushpak Kireeti J
  • 0

jpk0920
Rookie
 
Posts: 4
Joined: Dec 14, 2011
Reputation: 0

Re: 2007 macro showing error in 2010

Postby Sisyphus » Wed Dec 14, 2011 4:29 am

Hi,

I work with Excel 2003. But, seeing that you happen to be online, let me tell you this much:
Your question can't be answered the way you have put it. As a minimum you should post the procedure in which the error occurred.

When the arror hits Excel will highlight the command or reference that gave rise to to it. Your chances of getting a quick answer to your question will be greatly enhanced if you pass on this information. Press the Debug button on the error message to get to look at it.

Have a great day! :D
  • 0

Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010

Re: 2007 macro showing error in 2010

Postby jpk0920 » Wed Dec 14, 2011 9:01 pm

Sorry...

n the error dialogue box "End" and "Debug" are enabled. when I select "Debug" Excel is stopped working and closing automatically with in 10 sec and restarting. if I select "End" same excel stopped working and closing.

because of this i'm unable to get code where this error is comming.
  • 0

jpk0920
Rookie
 
Posts: 4
Joined: Dec 14, 2011
Reputation: 0

Re: 2007 macro showing error in 2010

Postby Sisyphus » Thu Dec 15, 2011 3:49 am

Hi,

Perhaps that is the way Excel 2010 does things, and perhaps the macro project is protected from viewing by the user. If the latter is the case, remove the protection and try again. In the former case post the code that causes the problem. It is one of the objects in the code that XL10 handles differently from XL07. People familiar with both may be able to tell from their experience. I won't, because I don't have such problems.

In fact, if you can identify the object (with the help of the Debug key) you may be able to google for a cure because such changes are usually well publicized both, by MS and other users facing the same dilemma as you do.

Post something that the experts can get their teeth into, and I'll wish you the best of luck. :D
  • 0

Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot], Google Adsense [Bot] and 44 guests