Long running operations
Hello
I have an Excel-file that interacts with MATLAB, some of the interactions can take quite a long time, when that happens a window comes up saying that "Microsoft Office Excel is waiting for another application to complete an OLE action. I understand that I should be able to get rid of this window by setting Application.DisplayAlerts to false during the operation. However instead I would like to show a model window of my own (without any buttons or such) with a message like "please wait" and then when the operation is completed I remove the window. Is that possible? AFAIK if I use a normal form and run Show() then I will not be able to close it from the code that created it, that have to be done in code belonging to the form, is that correct? -- Erik Wikström |
Long running operations
Hi Erick,
Follow this structure Sub StartMacro userform.show End sub Sub userform_Activate Call main Unload me end sub Sub Main 'do something End sub Regards JY "Erik Wikström" wrote in message ... Hello I have an Excel-file that interacts with MATLAB, some of the interactions can take quite a long time, when that happens a window comes up saying that "Microsoft Office Excel is waiting for another application to complete an OLE action. I understand that I should be able to get rid of this window by setting Application.DisplayAlerts to false during the operation. However instead I would like to show a model window of my own (without any buttons or such) with a message like "please wait" and then when the operation is completed I remove the window. Is that possible? AFAIK if I use a normal form and run Show() then I will not be able to close it from the code that created it, that have to be done in code belonging to the form, is that correct? -- Erik Wikström |
All times are GMT +1. The time now is 01:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com