Forum Discussion

BenEppel's avatar
BenEppel
New Contributor II
2 years ago

Table View VBA Refresh

Hello, I was wondering if anyone has been able to get a table view to refresh using VBA.  I have tried the below code with no luck. Sub RefreshXFFunctions() Set XFAddIn = Application.COMAddIn...
Excel Add In
JennyCalvache's avatar
JennyCalvache
New Contributor III
2 years ago

Hello, I was able to refresh with the following codes.

Set xfaddIn = Application.COMAddIns("OneStreamExcelAddIn")
If Not xfaddIn Is Nothing Then
If Not xfaddIn.Object Is Nothing Then


xfaddIn.Object.ShowParametersDlgForActiveWorksheet
xfaddIn.Object.RefreshXFFunctionsForActiveWorksheet

End If
End If

Hopefully this one helps if anyone needs to refresh Table view. However I can't refresh Table view without using xfaddIn.Object.ShowParametersDlgForActiveWorksheet. Does anyone know how?

Thanks in advance.

  • vignesh's avatar
    vignesh
    New Contributor II
    2 years ago

    Hello All, I am trying to avoid the step where user manually login in the excel OneStream Ribbon and then perform the Refresh Sheet with the macro button.

    Is there any function to login in the VBA code before the refresh..