Apex Code Development You need to sign in to do that
Don't have an account?
JimmyC1228 Refreshing Reports in Excel VBA
I am trying to write some code in VBA in Excel using the Office Edition toolbar to automatically refresh the reports in a workbook when a button is pressed. When I first open the file and press the button, Excel tells me that the requested file cannot be found. My code looks like this:
If Not (SFDCExcelAddin.CommandBarRelated.IsLoggedIn) Then
SFDCExcelAddin.CommandBarRelated.Login
End If
Sheets("Raw SalesForce Data").Select
SFDCExcelAddin.CommandBarRelated.RefreshAll
If I change RefreshAll to Refresh and then select the desired report, it works fine; so, I don't understand why RefreshAll can't find the report. Alternatively, if I manually refresh the report from the toolbar, and then run my subroutine it works. Does anyone have any idea what might be causing this or how to get around it? Also, does any one know where I can find documentation for the SFDCExcelAddin library so that I can better understand what the methods do and how to work with them? Thanks.
If Not (SFDCExcelAddin.CommandBarRelated.IsLoggedIn) Then
SFDCExcelAddin.CommandBarRelated.Login
End If
Sheets("Raw SalesForce Data").Select
SFDCExcelAddin.CommandBarRelated.RefreshAll
If I change RefreshAll to Refresh and then select the desired report, it works fine; so, I don't understand why RefreshAll can't find the report. Alternatively, if I manually refresh the report from the toolbar, and then run my subroutine it works. Does anyone have any idea what might be causing this or how to get around it? Also, does any one know where I can find documentation for the SFDCExcelAddin library so that I can better understand what the methods do and how to work with them? Thanks.
I have been using the formula reffered to by the person above to refresh all. Does anyone have a solution to simulate the commandbar function of refresh existing reports>"specific report reference". My issue is that "refreshing all" seems to crash excel 3/4 of the time, but found if I refresh one report at a time it works.
Any help/suggestions are appreciated.