S
Steven Kelder
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
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