Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running Code looses focus to Outlook and stops
Hi there, thanks for your attention!!! Windows XP/ Excel 2002
I wrote a program in VBA for Excel that compares data in 2 columns in 2 different sheets in 2 different workbooks. The code is in WorkBook1, and it performs its check on data in columns in WorkBook2 and WorkBook3. A form is shown Non-Modal, so the user can put the cursor on a column on a worksheet to compare, and click a button on the form so the program receives the information of the objects: ActiveWorkBook, ActiveSheet, and Column. The program runs fine, with one problem: When my Outlook performs its send/receive task, scheduled every 15 minutes, my VBA code stops, and does not start again. If I close all programs including Outlook everything works fine. Does this have somthing to do with showing the form Non-Modal ? Is there a solution to this ?? Thanks for your time !!! Steven Kelder |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code Stops Running Instead of Debugging | Excel Discussion (Misc queries) | |||
Instead of debugging, code just stops running | Excel Discussion (Misc queries) | |||
Weary Traveler Needs Assistance: Change Focus to Outlook Contacts | Excel Discussion (Misc queries) | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
why excel stops running?? | Excel Discussion (Misc queries) |