Automating XL charts from VB.NET 2003

A

Allan X

I have a few charts that are embedded into worksheets. All I need to do
is bring in new data worksheets and remap all series sources. Also, I
have to change all formulas to point to the new sheets, then delete
existing sheets.
Sounds easy...BUT...
I need to change the Category X Axis labels source and Secondary
Category Axis labels source, in order for Excel to allow me to delete
existing sheets. Can anybody help? Also, is the full object model map
for Excel objects available somewhere? Thanks in advance.

*** Sent via Developersdex http://www.developersdex.com ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Manipulating embedded excel charts in Word 0
Chart label alignment 0
Chart Rendering incorrectly in newer release of MSO 2007 12.0.6514 0
Automatically selecting active chart 4
Chartspace & Excel2003 0
XL 2010: Parent of a Range can be a Shape? 0
Axes(xlCategory) for a chart-sheet in 2007 2

Top