Perl. Basic. X-Cell - Solutions pour Excel. Querying External Data in Excel. The CommandText Property The CommandText property holds the SQL statement that defines the table in an External Data table.
This property holds a String data type which means it can be changed or manipulated like any other text. Excel Developer Tip: A Class Module to Manipulate a Chart SERIES. Excel's object model has a serious flaw: There is no direct way to to use VBA to determine the ranges used in a chart.
This tip contains a useful class module that can simplify the task of manipulating chart's using VBA. Background Information The Series object is contained in a Chart object. The SeriesCollection is a collection of Series objects for a particular Chart object. If a chart plots two data series it will have two Series objects. Excel. Excelabo le site du Disciplus.simplex, Astuces démos et jeux pou.