Can an XLSM GUI workbook opens its own instance when another instance exists?

[ez08mba]

Can an XLSM GUI workbook opens its own instance when another instance exists?

I've been researching this and found the link below here (at the forum) but I don't thinks this quite does what I hope I can do.

The issue I think is that the macro will open an instance, but I still need to give a path although the book I have sub located in opens from the workbook I want to open in a separate instance. Confusing I know. I can't hard code the path as some examples provide. The user could place this GUI workbook anywhere, so it needs to be able to open from any location and in its own instance if another instance exists.

I have messed with the following, but the same issue and it also close an existing instance, which can't happen.

Application.IgnoreRemoteRequests = True

Oh, BTW, when I decided this code was not what I wanted, I removed it, but the GUI workbook I added it to still continues to do the same thing though I removed the code.

Any comments welcome. Maybe it cannot be done.

https://www.mrexcel.com/forum/excel-questions/993780-force-macro-open-excel-file-new-instance.html

Thanks!

 

[Logit]

.
Did a little research. Everything found includes a hard coded path to the other workbook to be opened.

Just thinking out loud here ... maybe you could write a macro for searching a DIR and sub folders. The search
would be for the file name. Once located the macro could copy the path which would be used in the remainder
of the macro replacing a "hard coded path". The the workbook would be opened.

This method would require time for the search to be performed. Not optimal for most users.

 

[ez08mba]

.
Did a little research. Everything found includes a hard coded path to the other workbook to be opened.

Just thinking out loud here ... maybe you could write a macro for searching a DIR and sub folders. The search
would be for the file name. Once located the macro could copy the path which would be used in the remainder
of the macro replacing a "hard coded path". The the workbook would be opened.

This method would require time for the search to be performed. Not optimal for most users.

Hey Logit!

Interesting thought, and I will play with this idea. As you mentioned, probably not optimal, and for a few reasons. Maybe it will lead to a better idea along the way. I will post to the forum how it goes.

 

[ez08mba]

Hey Logit, it loops on itself. It's really paradoxical. I believe I can set it up in the OS registry so that each and every excel workbook opens in a separate instance but the user then has to navigate to the workbook from a current instance to open a second workbook if needed within that current instance for comparison.

 

[Logit]

.

it loops on itself

Include a line EXIT SUB immediately after the line of code that locates the file ?

Also consider something to the extent of .... If Workbook Open, Then Exit Sub