I am currently working on a vb program load excel object and do some work in them. The problem goes like this.
My Vb program creates and instance of excel and for this purpose let us say that the workbook created is book1.Using the GetObject method to access this instance would return book1 and works fine. I  manually open  a saved excel file "test.xls" from one of my drives effectively creating a second instance of excel. I now would like to load the second instance ("test.xls") in my vb program, using GetObject however always returns the first instance, in order to load "test.xls" in vb I would have to close the first instance then use GetObject. Assuming that I don't know the directory where the second instance("test.xls") came from, is there a method in vb to load the second excel instance without closing the first?