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

Guess I showed my ignorance.

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


"VeNoMiS" wrote in message
...
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