0 Replies Latest reply: Jun 4, 2014 3:13 PM by Trip RSS

    HypRetrieveRange in HFM


      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


      Sub HYPRET()


      X = HypRetrieveRange("BS Monthly", Range("C537:E537"), "APP1")


      End Sub