re: To VBA and beyond - building a RESTful backend using plain Microsoft Excel macros VIEW POST


This may not be ideal but if you call DoEvents in VBA your user interface will not be blocked. Though keeping a macro running indefinitely may be a bad idea.


I haven't seen DoEvents, yet. I just added it and now the GUI isn't blocking anymore, thus you could kill the server from the VBA window, too. Thank you!

code of conduct - report abuse