Hi Amol, I haven't use the Office Web Components, and we don't know much about your code or file, but the error is usually caused by a references/library problem, such as:
. You used early binding but the reference to the OWC library was broken. . The OWC library is not installed on the problem machines (regardless of early or late binding) . The library installed is a different version. You indicate you're using OWC10 - that was released with Office 2000, I believe, and is not generally recommended for use today. I'm not sure if OWC is recommended at all now - I haven't researched it! but the last version of Office web components was OWC11 (Office Web components for Office 2003). That can be downloaded at https://www.microsoft.com/en-us/download/details.aspx?id=22276. My reccomendations: . Upgrade to OWC11 (unless there is some reason not to that I am unaware of) . Make sure OWC is installed on all machines . Use late binding to avoid any problems with references (e.g., something like: Dim MyOWCObject As OBJECT .. Set MyOWCObject = CreateObject("OWC11.SomeOWCClassname") In any case, when the error occurs Some debugging and troubleshooting steps to take: . Determine if the variable ChartSpace2 contains the desired object. Verify that it's properties are what you expect. Verify that the ExportPicture method is being recognized. If you cannot be at the workstation when it fails, use debug.print statements to print the information you need to the Immediate window. . Does OWC10 support PNG graphics? I saw a reference that only mentioned GIFs. . If you find a problem considering the above suggestions or others that come to mind, work backwards through your code to determine when the problem first occurs, and then try to determine why. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amol Jadhav Sent: Thursday, November 08, 2012 10:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA : Class does not support automation error. Hello Experts, I need your expert advice. I created a tool using VBA form and OWC 10.0. I am exporting chart which is on chartspace component(OWC 10.0). On some PC's tool is working fine, but on other computers I am getting an error "Class does not support automation or does not support expected interface. I am using Windows 7 and office 2010 I am not able to upload file because its to heavy 19 mb. Please find attached error screenshot and highlighted line where i am getting this error. Please let know the possible reasons and solutions for the same. Regards, Amol J -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
