HypRetrieveNameRange

HypRetrieveNameRange refreshes the grid created by HypRetrieveRange.

HypRetrieveNameRange (vtSheetName, vtGridName)

ByVal vtSheetName As Variant

ByVal vtGridName As Variant

vtSheetName: For future use. Currently the active sheet is used.

vtGridName: Input variable, contains the name of the named range or grid to be refreshed.

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

Example 1

Public Declare Function HypRetrieveNameRange Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtGridName As Variant) As Long

Sub RetrieveAllRange()
'connect all required connections
sts = HypConnect("Sheet1", "admin", "password", "stm10026_Sample_Basic")
'get list of named grids available
sts = HypGetNameRangeList("Sheet1", "", vtList)
'refresh each range one by one
For i = 0 To 2
sts = HypRetrieveNameRange("Sheet1", vtList(i))
Next i
End Sub

Example 2

Public Declare Function HypRetrieveNameRange Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtGridName As Variant) As Long

Sub RefreshNameRange()
sts = HypRetrieveNameRange("Sheet1", "DMDemo_Basic_2") 
‘if you know the name of the grid, you can pass it directly 
End Sub