![]() |
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 |
All times are GMT +1. The time now is 08:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com