Excel .... Multiple Calls

[ElevenToes]

I am using a program to generate data and then post it to excel. Then I take that data and graph it for the user. This works fine the first time but once it has graphed the data I can not hit the graph button again. I get an error when it tries to generate a new series.

I would like to generate a new set of data and get it to either create a new graph in the current excel app (ideal) or open another one and repeat the process.

Thanks for any help....
Don

[Static]

I have done this...I would drop some code in but there is Sooooo much happening in this report you would not be able to figure head from tails.

ALl I had to do to repeat it though was reset ALL my variables. (it wound up creating a whole new workbook)
But I suppose you could make it delete the chart (or sheet) then re-create it with the new data.

Use the macros and edit the code for hints when your stuck