HypGetDrillThroughReports

HypGetDrillThroughReports() retrieves a list of drill-through reports. See also HypExecuteDrillThroughReport.

HypGetDrillThroughReports(vtSheetName,vtSelectionRange,vtIDs,vtNames,vtURLs,vtURLTemplates,vtTypes)

ByVal vtSheetName As Variant

ByVal vtSelectionRange As Variant

ByVal vtIDs As Variant

ByVal vtNames As Variant

ByVal vtURLs As Variant

ByVal vtURLTemplates As Variant

ByVal vtTypes As Variant

vtSheetName: For future use; currently the active sheet is used.

vtSelectionRange: The range of cells in which to execute the drill-through report

vtIDs: Output parameter; the array of the IDs returned from the server

vtNames:: Output parameter; the array of the names returned from the server

vtURLs:Output parameter; the array of the URLs returned from the server

vtURLTemplates:Output parameter; the array of the URL templates returned from the server

vtTypes:Output parameter; the array of the types returned from the server

Returns 0 if successful; otherwise, returns the appropriate error code.

Public Declare Function HypGetDrillThroughReports Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant,ByRef vtIDs As Variant,ByRef vtNames As Variant,ByRef vtURLs As Variant,ByRef vtURLTemplates As Variant,ByRef vtTypes As Variant) As Long

Sub HypGetDrillThroughReports()
sts = HypGetDrillThroughReports("Sheet3", Range("B3"), ids, names, urls, urltemplates, types)
End Sub