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