Launching a long macro while keeping excel available

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

Bob
Wed Jun 07 09:40:16 CDT 2006

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)

"matt23" <matthieu.metz@gmail.com> wrote in message
news:1149690661.487077.15700@y43g2000cwc.googlegroups.com...
> 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
>