J
Jacob
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.
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.