Pasting (charts) error from 2003 to 2007 (and 2010)

**tmd2** · 01-05-2011, 11:18 PM

Hi,

I have a macro that I wrote in 2003 but gives me an error (Run-time error '1004' Paste method fail) when I try to run it in in 2007 or 2010. I'm really not sure why. I'm basically creating a bunch of charts that comes from a varying amount of data. I have also attached a workbook so you can see what I am doing, The part where the error is thrown is wsCharts.Paste. Please any help is greatly appreciated.

Please Login or Register  to view this content.

**tmd2** · 01-06-2011, 03:20 PM

Sorry I made a mistake with the error I am receiving. The error says "method 'paste' of object '_worksheet' failed" Please any help at all is greatly appreciated.

Thanks

**Andy Pope** · 01-07-2011, 06:36 AM

I could not get the code to fail.

You might try referencing the 1st chartobject rather than the complete collection.

Please Login or Register  to view this content.

**tmd2** · 01-07-2011, 06:16 PM

Wow Andy that worked great! I can't thank you enough! I'm not sure why it worked in 2007 for you and not me. I tried it on several machines. If you don't mind(and have the time) could you tell me what exactly the difference is? It seems like it should work either. Is the way I originally had it saving the stored cut code for the collection of charts, and now just for the 1st Chart object? Then I suppose 2007 can't paste a collection for some reason? Or am I completely off? Thanks so much again I can't tell how much I appreciate it.

Tom

**Andy Pope** · 01-08-2011, 08:07 AM

I don't know the exact reason but the object model for charting and shapes was rewritten for xl2007. So things not working as they did in xl2003 is just to be expected and worked around, if possible.

**tmd2** · 01-08-2011, 07:52 PM

Ok makes sense...Thanks a lot again for your help.

**vhamuche** · 02-03-2011, 03:44 PM

Hey,

Great work!

I have a question, is it possible to view one of your charts` data as a column and the others as a line chart overstacked together?

For example, stock mkt charts with financial volumes beneath.