terminating remote links?
 

I have been trying to get around the problem of a userform interacting
with the wrong workbook, when I have more than one workbook open. I
discovered the following code which causes other workbooks to open in a
new instance of excel:

Application.IgnoreRemoteRequests = True

this works great, but I realized a few things that are causing
problems.

1. although I added Application.IgnoreRemoteRequests = False to the
close sub, I am still afraid that it does not guarantee that this will
be shut off. maybe the form won't be closed that way, or a crash etc.
and that causes problems when trying to open another workbook.

2. is there a way to make a workbook open in it's own instance of
excel, rather than in an existing application?

3. is there a way to eliminate the warning message (existing remote
links will be terminated) that appears when setting
Application.IgnoreRemoteRequests = True?

or if there is a better way to bind a workbook with changing filename
to a userform, that would be nice. thanks.

terminating remote links?
 

any ideas?

On Nov 10, 7:59 am, "Jacob" wrote:
I have been trying to get around the problem of a userform interacting
with the wrong workbook, when I have more than one workbook open. I
discovered the following code which causes other workbooks to open in a
new instance of excel:

Application.IgnoreRemoteRequests = True

this works great, but I realized a few things that are causing
problems.

1. although I added Application.IgnoreRemoteRequests = False to the
close sub, I am still afraid that it does not guarantee that this will
be shut off. maybe the form won't be closed that way, or a crash etc.
and that causes problems when trying to open another workbook.

2. is there a way to make a workbook open in it's own instance of
excel, rather than in an existing application?

3. is there a way to eliminate the warning message (existing remote
links will be terminated) that appears when setting
Application.IgnoreRemoteRequests = True?

or if there is a better way to bind a workbook with changing filename
to a userform, that would be nice. thanks.