Description
Specifies or returns the Excel application object which the BDK graphing functions should use to generate graphs if the Destination property is set to BDKExcel. Unless you set this property yourself, the first graphing function you call will launch a copy of Excel and set this property automatically. Subsequent graphing calls will use the same copy of Excel.
Syntax
object.ExcelServer
Arguments
None.
Return Value
(Object) – the Excel object. Note, this is a late-bound object, so you do not need to include a reference to the Excel object library in your project.
Example
'Make a graph, then retrieve the Excel object used
BDKApp.GraphDefaults.Destination = BDKExcel
BDKApp.Outputs(1).Results.Graph BDKCurveTypeDensity
Set xlApp = BDKApp.GraphDefaults.ExcelServer