I have some Excel VBA code that I can call from a PC-DMIS script and it will pull data out of PC-DMIS, manipulate it, and then push it back in. If I generate any message boxes in Excel while this is happening I will get a Server Busy error message if the user doesn't respond to the message box within a few seconds. Does anyone know how to disable this message? I just want it to wait as long as necessary for Excel to finish what it is doing.
I understand PC-DMIS is the source of the 'Server Busy' error but the cause is from Excel showing a message box or something like that.
If the contents of the macro was outside of Excel you won't get message boxes in Excel and therefore no 'Server Busy' errors from PC-DMIS.
It is just an observation I noticed recently regarding error messages from Excel when manipulated externally. It is nice to try and keep this kind of stuff simple and clean if possible. Anything too complex or with too many steps involved is more likely to break.
I understand PC-DMIS is the source of the 'Server Busy' error but the cause is from Excel showing a message box or something like that.
If the contents of the macro was outside of Excel you won't get message boxes in Excel and therefore no 'Server Busy' errors from PC-DMIS.
It is just an observation I noticed recently regarding error messages from Excel when manipulated externally. It is nice to try and keep this kind of stuff simple and clean if possible. Anything too complex or with too many steps involved is more likely to break.
