Skip to Content
0
Former Member
Dec 05, 2012 at 07:12 PM

10NW Macro issue in refresh report

22 Views

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.