I want to refresh thedata thru the push button and following is the VBA coding with
macro in place.
Sub Refresh_Click()
'This sub will refresh the worksheet
Dim EPMObj As FPMXLClient.EPMAddInAutomation
Set EPMObj = New EPMAddInAutomation
'refresh the worksheet
EPMObj.RefreshActiveSheet
'clean up code
Set EPMObj = Nothing
End Sub
The vba/macro is working but refreshing the whole report and I am loosing manual format put in place.
Is there any macro to ensure that only the data is refreshed and not the who report is refreshed.
Appreciate your inputs.