-
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
-
It can be done...
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