ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Running Code looses focus to Outlook and stops (https://www.excelbanter.com/excel-programming/286683-running-code-looses-focus-outlook-stops.html)

Steven Kelder

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