Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-08-2013, 11:15 AM
hlina hlina is offline Automation error Unknown error" message once they open the Excel file Windows 7 64bit Automation error Unknown error" message once they open the Excel file Office 2010 32bit
Novice
Automation error Unknown error" message once they open the Excel file
 
Join Date: Oct 2013
Posts: 1
hlina is on a distinguished road
Default Automation error Unknown error" message once they open the Excel file

Dear forum members:

Unfortunately I have an - for me - very urgent problem. I recently revised a very long macro and put it online. Now I got mails from users stating that they receive an "Automation error Unknown error" message once they open the Excel file. Unfortunately, I cannot reproduce this problem directly on any of my computers - it works flawlessly here. On the net, I have only found some information that this error may be related to security updates KB2687441 (in Office 2007) or KB2597986 (in Office 2010).



The Excel file consists of many tables with VBA code, so I cannot post the complete macros here. Do you have a tip on how I could go to the source of the problem - maybe Excel puts an insightful log file somewhere, so that I can reproduce such a problem on my own machine in order to troubleshoot it?

So far, I have tried the following: On my computer, I renamed the registry key
HKCR\typelib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0
to " 2.1" and added a new empty key "2.0". After this, I am getting this error message. With KB2687503 I can fix the error. But: How do I know if that is the problem for the other users? I would hate to let them test things stupidly.

Cheers,
Hlina
Reply With Quote
  #2  
Old 10-08-2013, 09:14 PM
BobBridges's Avatar
BobBridges BobBridges is offline Automation error Unknown error" message once they open the Excel file Windows 7 64bit Automation error Unknown error" message once they open the Excel file Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 676
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

Maybe I'm just exposing my ignorance, but these users who are having the problemódo they get the "Debug"-button option? Because if they do, you can have them hit that button, then tell you what statement the macro bombed on. That, at least, would narrow it down for you.

If that button isn't offered, all that occurs to me is a) to go to one of their machines yourself, personally, and run and debug it there, or b) to select a reasonably savvy victim who's having the problem and seems up to learning a little; have that person put breakpoints at different places in the program and run it experimentally, narrowing the search until you've zeroed in on the place that's causing the problem. Oh, wait, you said this problem was occurring when they open the workbook, so no setting breakpoints. So they'd have to insert either Stop statements or MsgBox calls to accomplish the same thing. It's a pain, but it's at least guaranteed to get you eventually to the source of the problem.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error message: Can't sync, file too big Delta223 Office 0 07-16-2013 06:56 AM
Automation error Unknown error" message once they open the Excel file Word 2003 "The information you were working on might be lost" constant error message rocketbeta Word 1 08-21-2012 02:54 PM
"unknown error when deleting emails" jswisher Outlook 1 09-24-2010 04:13 PM
The Message interface returned an unknown error. If the problem presists, restart out RolandVet Outlook 2 04-18-2010 04:54 AM
Automation error Unknown error" message once they open the Excel file MYOB and "Item.Send error" Outlook message peter_lambros Outlook 1 12-06-2008 08:24 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft