Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting The Chart Wizard To Appear
Hey folks,
I'm working on a data automation project for PowerPoint. In PowerPoint, I give the user the option to create a new Excel chart and then drag and drop it onto the PowerPoint form. I've got it working, but now I need to give the user all the same options that the standard Excel Chart Wizard offers. Rather than recreate the entire Excel Chart Wizard, is there a way that I can get it to appear/open up? Note: I'm writing this in C# and I have access to all the excel objects including application, workbook, worksheet, chart, chartarea... Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting The Chart Wizard To Appear
I don't know how you need to handle it in C#, but the VBA command to launch
a commandbar command is: Application.CommandBars.FindControl(Id:=436).Execu te This little piece of code in the Immediate Window told me the appropriate Id: ?application.CommandBars("Standard").Controls("Cha rt Wizard").Id 436 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "John Smith" wrote in message ... Hey folks, I'm working on a data automation project for PowerPoint. In PowerPoint, I give the user the option to create a new Excel chart and then drag and drop it onto the PowerPoint form. I've got it working, but now I need to give the user all the same options that the standard Excel Chart Wizard offers. Rather than recreate the entire Excel Chart Wizard, is there a way that I can get it to appear/open up? Note: I'm writing this in C# and I have access to all the excel objects including application, workbook, worksheet, chart, chartarea... Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Chart Wizard | Excel Discussion (Misc queries) | |||
Chart Wizard | Charts and Charting in Excel | |||
Chart Type toolbutton instead of Chart Wizard | Charts and Charting in Excel |