I have come across a trait of Excel which I'm not sure to get around, but I really need to.
At the moment I have an Excel add-in that opens up an Admin-type file.
If the user runs a macro that needs to open up this Admin-type file (file containing user info etc etc) then the
admin file, the data retrieved and then closed (all pretty straight forward)-however (and here is the problem as I see it) the Book1.xls workbook that existed before the Admin-type file was opened is now GONE...
I have found that this occurs in normal circumstances (without a macro) in that if a workbook is immediately opened when Excel is opened then the Book1.xls workbook no longer appears (it closes).
I tried this by opening Excel (without my add-in) and then just opening a file and found that Book1.xls no longer appears.
Why is this??? :o
It's just that I would like this book to still be there when my add-in opens (and then closes) the admin file.
Any thoughts, suggestions or questions would be very much appreciated.
Thanks in advance...