Move a workbook from one instance of excel applicaiton to another

[Alan]

Hi All,

Is there any way to move an workbook from one instance of the excel
application to another?

I have been looking at using the ByRef method of calling a sub in the
second instance from the first instance and using the workbook as the
argument ByRef, and then killing it in the first instance, but this
does not appear to work.

Any ideas would be most welcome.

Thanks,

Alan.

--
The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:

(e-mail address removed)

This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address

 

[Dave Peterson]

You'll have to open the workbook in the same instance to run that macro.

But you could open it readonly, run the code, close without saving.

 

[Alan]

You'll have to open the workbook in the same instance to run that
macro.

But you could open it readonly, run the code, close without saving.

Okay - thanks Dave.


--
The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:

(e-mail address removed)

This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address