Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

i need to find Excel active X object mschart.ocx or mschrt20.ocx.

Where are they laying?

Thanks!

P.S:

Am i right, that they can help me to use active x chart: msdn

Thanks!

share|improve this question

1 Answer 1

up vote 1 down vote accepted

You don't need to know about the OCX to use this control in Excel, support is built-in.

Simply add a chart to your worksheet.

Charts are also exposed in VBA for programmatic use.

As is often the case, if you record a macro while inserting a chart, you will get some code that will point you in the right direction.

Worksheets have a "ChartObjects" collection that you can work with.

You can programmatically add a chart to a worksheet with something like:

Set myChart = ActiveSheet.Shapes.AddChart.Chart

UPDATE 2012-05-18: Following up on the comment below. I think that charting is embedded in one of the Excel DLL's.

You can get the chart controls from Microsoft:

(GRRR! I can only put 2 links in here!! I'll add another comment for the other 2)

share|improve this answer
    
i know, how to do it. I need active x to interact vba-script with matlab. Matlab must display chart, that it get from vba-script –  gaussblurinc May 16 '12 at 17:33
    
- [Microsoft Chart Controls for .NET Framework Documentation][1] - [Security Update for Microsoft Chart Controls for Microsoft .NET Framework 3.5 Service Pack 1 (KB2500170)][2] [1]: microsoft.com/en-us/download/details.aspx?id=11001 [2]: microsoft.com/en-us/download/… –  Julian Knight May 18 '12 at 11:18

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.