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 believe you will not have 'Server Busy' related problems if the VBA code was not inside Excel (not executed from within Excel).
Recently I was trying to solve a problem where a workbook sheet, when duplicated by external methods (an external VB script for example), caused some text to be truncated to a maximum of 255 characters. Once particular cell in the sheet contained about 20 or 30 characters more than this upper limit. I had no idea why the text was truncated and spent a lot of time looking at everything that might cause this. At some point I tried to manually duplicate the workbook sheet and this was the first time I saw the Excel error message box stating that some cells would be truncated to 255 characters. When I Googled the message I understood the problem, the reasons, and worked out a solution (my solution was to copy the text and write it into the same cell of the duplicated sheet. The text is still truncated when the sheet is duplicated but I don't care since I update the text using the copy from the original). No error messasge popup's appear when controlled externally, I only saw them when interacting directly with Excel.
I believe you will not have 'Server Busy' related problems if the VBA code was not inside Excel (not executed from within Excel).
Recently I was trying to solve a problem where a workbook sheet, when duplicated by external methods (an external VB script for example), caused some text to be truncated to a maximum of 255 characters. Once particular cell in the sheet contained about 20 or 30 characters more than this upper limit. I had no idea why the text was truncated and spent a lot of time looking at everything that might cause this. At some point I tried to manually duplicate the workbook sheet and this was the first time I saw the Excel error message box stating that some cells would be truncated to 255 characters. When I Googled the message I understood the problem, the reasons, and worked out a solution (my solution was to copy the text and write it into the same cell of the duplicated sheet. The text is still truncated when the sheet is duplicated but I don't care since I update the text using the copy from the original). No error messasge popup's appear when controlled externally, I only saw them when interacting directly with Excel.
