Hi,
I have a workbook that is connected to my BI database through Power Pivot. I have some VBA which refreshes all the connections & creates the workbook. I would like some VBA that brings up an error message if one of the connections fails to refresh - similar to if I was to refresh through 'data', 'refreshAll'.
At the minute the end user doesn't know if the refresh has been successful or not. for example, if i was to disconnect for my organisations network and refreshed through 'data', 'refreshAll' i get the following error message
Whereas when i process my macro, there is no error message and as far as the end user is concerned the workbook has refreshed. The VBA refresh i am using is 'ThisWorkbook.RefreshAll'
Thanks,
Chris
I have a workbook that is connected to my BI database through Power Pivot. I have some VBA which refreshes all the connections & creates the workbook. I would like some VBA that brings up an error message if one of the connections fails to refresh - similar to if I was to refresh through 'data', 'refreshAll'.
At the minute the end user doesn't know if the refresh has been successful or not. for example, if i was to disconnect for my organisations network and refreshed through 'data', 'refreshAll' i get the following error message
Whereas when i process my macro, there is no error message and as far as the end user is concerned the workbook has refreshed. The VBA refresh i am using is 'ThisWorkbook.RefreshAll'
Thanks,
Chris