View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
VeNoMiS VeNoMiS is offline
external usenet poster
 
Posts: 3
Default How To Open Chart Wizard Dialog on Excel 2003

Based on msdn

CommandBarControl FindControl(
[In, Optional] object Type,
[In, Optional] object Id,
[In, Optional] object Tag,
[In, Optional] object Visible,
[In, Optional] object Recursive
);

"Jon Peltier" wrote:

At the risk of showing my ignorance, wouldn't the control ID be a long?

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


"VeNoMiS" wrote in message
...


"Jon Peltier" wrote:

Not all dialogs work in this way. If you need to show the chart wizard,
you
could use this instead (this is the VBA, it's up to you to find the C#
equivalent):

Application.CommandBars.FindControl(Id:=436).Execu te

This finds the Insert Chart control and executes it, which pops up the
chart
wizard.

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



I've tried this code

object id = 436
excel.CommandBars.FindControl(missing,id,missing,f alse);

but doesn't work