Thanks a lot Asa. Regards, Amol Jadhav
On Sat, Nov 10, 2012 at 4:51 AM, Asa Rossoff <a...@lovetour.info> wrote: > 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. > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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.
