Problem with excel workbook switching

[King]

Hi,
I am running an excel macro that fatches data from the database and
generats excel reports on multiple sheets. This process sometimes takes
about an hour or two. But during this retrieve process, users are not
able to open a new excel workbook, or they can not even open
aready-opened excel workbooks. Users can not minimize the excel
workbook where the process is going on, and can not even switch the
already open excel workbooks.

Is there anything I should set in the code to allow users to switch the
workbook?

Thanks in advance.

 

[Karim Benabd]

Try DoEvents

 

[NickHK]

Create a new, hidden instance of Excel to do your processing, leaving the
user free to continue in the existing instance.

Dim MyXLApp As excel.application
set myxlapp=new excel.application

Now direct all your code to this instance.

NickHK