Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Long Long Long Nested If Function | Excel Discussion (Misc queries) | |||
Long time to open spreadsheet (running Excel 2007) | Excel Discussion (Misc queries) | |||
Status bar (or similar) to appear whilst running a long macro | Excel Discussion (Misc queries) | |||
Long running macro and screen update | Excel Programming |