Launching a long macro while keeping excel available

M

matt23

Good afternoon,

I currently have an excel workbook in which I regularly launch a very
long macro M1 (about 15 mn).
To sum things up, my workbook is made up of 2 sheets:
- one sheet on which I am always working, and where real-time data is
updated
- one data sheet.

The M1 macro does a refresh of my data sheet. While M1 is running, my
main sheet is not available anymore.. I have to wait for the end fo
this update to work again. .

I would like to launch M1 from my workbook in a new excel application
so as to continue working on my current sheet, and import the data when
it's over.

M1 can be launched (from a toolbar that I created) by different users
at the same time, but I can allow only one M1 to run at a time. I
therefore need to be able to specify to the user that M1 is already
launched.

I don't really know what I will be able, but I would really appreciate
any help you might give me.

Thank You
 
B

Bob Phillips

I suggest the following

- look at CreateObject to launch a new instance of Excel

- when you open the workbook in that instance, check if it has been opened
read-only (a workbook property). If some give a nice message and Quit.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top