Data provider types: All
Description
HypGetSheetInfo() retrieves detailed information about the requested worksheet.
Syntax
HypGetSheetInfo(vtSheetName, itemNameList, itemValueList)
ByVal vtSheetName As Variant
ByRef vtItemNameList As Variant
ByRef vtItemValueList As Variant
Parameters
vtSheetName: Sheet name. If “Empty” is passed, then current worksheet information will be retrieved
vtItemNameList: List of the titles of sheet information
vtItemValueList: List of corresponding values of titles of Sheet information
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Sub test()
Dim namelist As Variant
Dim vallist As Variant
ss = HypConnect("Sheet1", "admin", "password", "Conn123")
ss = HypRetrieve(“Sheet1”)
sts = HypGetSheetInfo("Sheet1", namelist, vallist)
End Sub