Simplify formula in Aspen Data Browser Add-in

[lunatic]

Hello to all

I want to simplify a formula of Aspen Process Data Add-In, this formul
are necessary 13 parameters, where 3 varian and the others ar
constant.

=ATGetAgg(TAG,Server,Map,StartTime,EndTime,Pediod,Calculation,AggMethod,AggStep,AnchorDsAdjust,NDSetting,Norientation,NTagDirection)

Parameters:

TAG
Server --->Constant
Map --->Constant
StartTime
EndTime
Period --->Constant
Calculation --->Constant
AggMethod --->Constant
AggStep --->Constant
AnchorDsAdjust --->Constant
NDSetting --->Constant
NOrientation --->Constant
NTagDirection --->Constant

I want a formula that contain 3 parameters:

e.g.: =Aspen(TAG, StartTime, EndTime)

and the result is identical like original formula ATGetAgg.

Sorry for my english.

Thanks

 

[Dave Peterson]

You could call that ATGetAgg() using your own function:

Option Explicit
Function Aspen(Tag, StartTime, EndTime) As Variant
Aspen = Application.Run("workbookwithfunction.xls!atgetagg", _
Tag, _
"Server", _
"Map", _
StartTime, _
EndTime, _
"Period", _
"Calculation", _
"AggMethod", _
"AggStep", _
"AnchorDsAdjust", _
"NDSetting", _
"NOrientation", _
"NTagDirection")
End Function

Replace each quoted string with the constant you want--including numbers.