prevent msgbox stops running macro

[incobart]

Hi

I have a workbook that every 10 min update some api data.
I have a few macros running that handel that data (also sceduled on time)
1 macro that run every hour, has also a line that let the workbook save (backup)

The problem now is that if he want to save at the moment an api update is running, a msgbox appears that say " this action wil ends the current update, ok/cancel.
A msgbox put everything on stop ... macros not go on .. so if it is night or I am not there.. my whole system stops ..

is there a way to auto answer this msgbox "cancel" ..
or is there a way to prevent api update starts before this macro is finished ?

Thanks
Chris

[kev_]

1. Try this
BEFORE the line which causes the message to appear

Please Login or Register  to view this content.

AFTER

Please Login or Register  to view this content.

2. If you call the API update from within the macro, it would give you control over the timing of the update. The file save and API update should not conflict if you do that.

You may need to introduce a delay to allow the update to complete - this delays things by 10 seconds

Please Login or Register  to view this content.

[incobart]

Thanks kev !

[kev_]

Please Login or Register  to view this content.

[incobart]

Kev, can you explain me short how i can move the api update (wich I do direct in the table now (right click)) into my macro ?

thanks

[kev_]

Set updates to manual:
Data \ Connections \ Refresh every check box shouild not be checked

Add one of the lines in post#4 to your VBA

[incobart]

ok, thanks, I try it out and let you know (maybe tomorrow)

[incobart]

Hi Kev,

something came in between, but tested your solution now and it is perfect ! Have to select out the 3 checkboxex at the table property = also allw background update.

thanks
Chris

[kev_]

Thanks for added reps
Please click Thread Tools at top of thread and mark thread as SOLVED