johnny51981
Active Member
- Joined
- Jun 8, 2015
- Messages
- 366
I'm trying to make my reports a bit more not-me user friendly, so when I'm out the person covering me doesn't have to get too technical. (I'm just saying "dumb down" in a nicer way).
Anyhow.
The last thing that I am not able to get built in is basically an emergency override. The reports all currently have VBA written in to refresh Power Queries and then export, save, do a twirl, and say goodbye. There are cases where I need to stop everything mid refresh for one reason or another, and know how to cancel the queries no problem, but there are some resetting steps that also need to be done.
Is there some code where I can cancel the Refresh All? If so, what would that look like?
Anyhow.
The last thing that I am not able to get built in is basically an emergency override. The reports all currently have VBA written in to refresh Power Queries and then export, save, do a twirl, and say goodbye. There are cases where I need to stop everything mid refresh for one reason or another, and know how to cancel the queries no problem, but there are some resetting steps that also need to be done.
Is there some code where I can cancel the Refresh All? If so, what would that look like?