Can anyone see any faults in my macro below. Trying to retrieve a small set of data in Smartview with HFM. I know the function says ad hoc only in the admin guide, but the HypRetrieve works fine for refreshing hsgetvalue formulas. No errors come back, nothing happens when I run it.
Declare Function HypRetrieveRange Lib "HsAddin.dll" (ByVal vtSheetName As Variant, ByVal vtRange As Variant, ByVal vtConnName As Variant) As Long
X = HypRetrieveRange("BS Monthly", Range("C537:E537"), "APP1")