Blocking the use of Excel
Posted on 1998-11-11
My application uses CreateObject("Excel.Application") to create an Excel object with is then used to write data to a number of workbooks. The problem is when someone double clicks on a .XLS workbook it is opened in my copy of excel. I don't want this to happen. My currect solution involves my application determining if there are more workbooks open than it expects and if there are the unwanted workbook is opened in its own copy. This works for most cases, but if the user attempts to open the same workbook twice My copy of excel displays a dialog (as two copies of the workbook are open) forcing my copy to be visable. Any ideas anybody. Thanks.