How To Open Chart Wizard Dialog on Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VeNoMiS - 26 May 2008 16:05 GMT

Hi All,
I need to open the Chart Wizard Dialog by c# code

my code is the follow

excel.Dialogs[mode].Show(missing x30);

where
excel = new Excel.Application
mode = xlDialogChartWizard
missing = System.Type.Missing;
show has 30 args so i repeat missing 30 times

this code works for the xlDialogPivotTableWizard dialog

Help me pls

Thx in Advance

Reply to this Message

ShaneDevenshire - 26 May 2008 22:52 GMT

Hi,

I don't know a thing about C#, but why not exclude the Show arguments?

Signature

Cheers,
Shane Devenshire

> Hi All,
> I need to open the Chart Wizard Dialog by c# code
[quoted text clipped - 14 lines]
>
> Thx in Advance

Reply to this Message

Jon Peltier - 27 May 2008 00:46 GMT

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).Execute

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
_______

> Hi All,
> I need to open the Chart Wizard Dialog by c# code
[quoted text clipped - 14 lines]
>
> Thx in Advance

Reply to this Message

VeNoMiS - 27 May 2008 11:43 GMT

> 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#
[quoted text clipped - 11 lines]
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______

I've tried this code

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

but doesn't work

Reply to this Message

Jon Peltier - 27 May 2008 12:45 GMT

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
_______

>> Not all dialogs work in this way. If you need to show the chart wizard,
>> you
[quoted text clipped - 20 lines]
>
> but doesn't work

Reply to this Message

VeNoMiS - 27 May 2008 13:21 GMT

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
);

> At the risk of showing my ignorance, wouldn't the control ID be a long?
>
[quoted text clipped - 29 lines]
> >
> > but doesn't work

Reply to this Message

Jon Peltier - 27 May 2008 20:49 GMT

Guess I showed my ignorance.

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

> Based on msdn
>
[quoted text clipped - 40 lines]
>> >
>> > but doesn't work

Reply to this Message