can i add excel chart from C++ without making it visible right away?

  • Thread starter Thread starter Dotan
  • Start date Start date
D

Dotan

i want to do something like that :
m_charts.Add(...) in a new worksheet
but i don't want to view it until i finish to mess around
with it.

p.s:
does anyone know how can i get the Automation functions
(excel9) help? i want to know what are the charts.add
arguments are...
 
I don't know how you would implement these suggestions from C++, but
here's what I'd suggest within VBA.
i want to do something like that :
m_charts.Add(...) in a new worksheet
but i don't want to view it until i finish to mess around
with it.
Click to expand...

Put

Application.ScreenUpdating = False

at the beginning of the routine and

Application.ScreenUpdating = True

at the end.
p.s:
does anyone know how can i get the Automation functions
(excel9) help? i want to know what are the charts.add
arguments are...
Click to expand...

Don't you have Excel? Open Excel, press Alt+F11 to open the VB Editor,
press Ctrl+G to open the Object Browser. Scroll down the list of classes
on the left until you find Charts, and select Add from the methods on
the right. There is a small bit of information at the bottom of the
Object Browser, and you can press F1 to get a more detailed description.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top