AgentSilverfern
Board Regular
- Joined
- Oct 16, 2003
- Messages
- 51
I am writing a mini-programme in an Excel workbook which I would like to open in an Exclusive instance of Excel. What i mean is this..
1. When one or more instances of Excel are already open and the user
opens my mini-programme, it will autmoatically open itself in a new
instance of Excel.
2. When my mini-programme is already open and the user tries to open
another Excel workbook, the user's workbook will be forcibly opened in a
new instance or other existing instance of Excel.
I have previously come across a solution to part 1. of my problem, which led me to the discovery that you can send a workbook that is being opened to a new instance of Excel no problem because when you create a new instance it is identifiable by the fact it becomes the active instance, but i have not found any manner in which an existing inactive instance of Excel can be made active and thereby identified in any way.
I know this might sound like a cumbersome way of doing something, but this is what I am working with, so it would not be suitable for me to use Add-Ins or any other means to solve this problem. I need to know if it can be done this way. Can you help?[/b]
1. When one or more instances of Excel are already open and the user
opens my mini-programme, it will autmoatically open itself in a new
instance of Excel.
2. When my mini-programme is already open and the user tries to open
another Excel workbook, the user's workbook will be forcibly opened in a
new instance or other existing instance of Excel.
I have previously come across a solution to part 1. of my problem, which led me to the discovery that you can send a workbook that is being opened to a new instance of Excel no problem because when you create a new instance it is identifiable by the fact it becomes the active instance, but i have not found any manner in which an existing inactive instance of Excel can be made active and thereby identified in any way.
I know this might sound like a cumbersome way of doing something, but this is what I am working with, so it would not be suitable for me to use Add-Ins or any other means to solve this problem. I need to know if it can be done this way. Can you help?[/b]
