Create a new instance of excel when opening a workbook

[Malc8179]

Hi Guys

I have a excel spreadsheet that when its opened it needs its own instance of excel have you any ideas on how i can achive this

Malc

 

[TonyJollans]

You could check, on opening, whether there were any other workbooks open and, if so, close it, create a new instance, and open it in there. What would be harder would be making sure that no other workbooks were opened in that instance later. Or, if you're using automation to open it in the first place, just create a new instance every time.

But, why does it need a separate instance?

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[combo]

I like to use free Sysinternals Desktops (among others, a part of recent Sysinternals Suite). I open a new desktop and excel instance here and continue work in first desktop. No problem with mixing instances.

combo

 

[Malc8179]

Thanks guys



Reason for two instances is i'm using forms within excel, set to show model false and when the user moved its focus to another workbook the combo boxes created an error


Managed to sort in another way (stopped the users moving focus from workbook)