View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Allan X Allan X is offline
external usenet poster
 
Posts: 1
Default Automating XL charts from VB.NET 2003



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 ***