Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switching to other apps while running macros in excel 97
Good excuse to get a cup of coffee, eh Dave?
Dave Peterson wrote: If the doevents stuff doesn't work, I have a couple of time consuming macros at work. When I run those, I stay away from the mouse and keyboard. I started them in xl97, but use xl2k now. But (for me), it's worth the 5-20 minutes to stay away. Mike Obertik wrote: I have written a macro in excel 97 that takes quite a while to run because it opens up another excel file, reads info from a server, then creates an excel file, transfers settings from the original file to the new file and then saves the new file. The macro runs perfectly, except when I switch to other applications (such as Internet Explorer or Lotus Notes) while it is running. I have found that a minute or two after I have switched away from excel and left the macro running, it sometimes crashes. Another problem is that the macro sometimes seems to hang when I switch to other apps instead of running through all the code timeously. It will start running normally as soon as I switch back to Excel Are these common problems with Excel 97? Are there certain commands or calls I should avoid? Is there a trick to making a macro run smoothly when switching to other apps? Regards Mike *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switching to other apps while running macros in excel 97
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switching to other apps while running macros in excel 97
Just to add my pennies worth:
My Excel also crashes under similar circumstances and now I'm coffee logged... steve "Dave Peterson" wrote in message ... And I can tell others that I'm hard at work, too. (I _did_ click the button before I got up, didn't I?) Jon Peltier wrote: Good excuse to get a cup of coffee, eh Dave? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - Alt-E hotkey does not work in MSOffice apps, no prob in other apps | Excel Discussion (Misc queries) | |||
Running Macros in Excel 2003 | Excel Worksheet Functions | |||
Running macros on ALL Excel tabs | Excel Worksheet Functions | |||
VBA Switching Between Macros | Excel Discussion (Misc queries) | |||
Running macros when Excel starts up | Excel Discussion (Misc queries) |