Reading through an existing chart
Hi,
I am wondering what is the best way to read through an existing chart. For example, lets say I have a chart on my worksheet:
A B
1 5
2 6
3 7
4 8
How would I go retrieve each element in that order?
I am new to VBA, so syntax might be a problem. Thank you very much!
Re: Reading through an existing chart
I have yet another question.
Is there a way in VBA to read and save objects in an existing .xls file and printing them to another?
For example, I have an existing .xls file with charts and graphs. Is there a way to read each chart and graph, and print them out into another .xls file?
I have searched everywhere if this is possible, but can not find an answer. Thanks!