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

    HypRetrieveRange in HFM

    Trip

      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