We have a list of worksheets which is programmatically scanned a chart
generated for each one. The worksheets are not in alpha sorted order. The
chart tabs are named like the corresponding data tab with the word "graph"
appended - i.e. 'MIDC' for data and 'MIDC graph' for the chart. We would like
to generate an ordered list of data/graph pairs - i.e.:

ABLE2 | ABLE2 graph | Bob1T | Bob1T graph | Demo OFF | Demo OFF graph

Is there a way to do this? We have office 2003. apparently charts and
worksheets are in two separate collections, and we can't figure out how to
get them to position relative to each other correctly.

DUH! the Sheets collection does the trick. (master collection that holds all
sheets - worksheets + charts)

"lavalamp" wrote:

We have a list of worksheets which is programmatically scanned a chart
generated for each one. The worksheets are not in alpha sorted order. The
chart tabs are named like the corresponding data tab with the word "graph"
appended - i.e. 'MIDC' for data and 'MIDC graph' for the chart. We would like
to generate an ordered list of data/graph pairs - i.e.:

ABLE2 | ABLE2 graph | Bob1T | Bob1T graph | Demo OFF | Demo OFF graph

Is there a way to do this? We have office 2003. apparently charts and
worksheets are in two separate collections, and we can't figure out how to
get them to position relative to each other correctly.