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:



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

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 wrote:

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:



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

"Dave Peterson" wrote in message

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 wrote:

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:



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


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:



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