Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Taking control of an existing instance of Excel
I have two questions about gaining control of an already-running instances
of excel that was started from the Start/Programs menu, *NOT* from VBA code. 1. Does anyone know how to locate and close a workbook named "daily.xls" that is open in another already existing instance of Excel that was *NOT* started from VBA code, and thus does *NOT* have an object reference to use in the VBA code of the instance of Excel that I am working from ? 2. Also, is it possible that after you have a way to reference the other instance of Excel, that you can crate an object, and set it to the already-open other instance of Excel to gain control of it for other actions besides just closing it? I know how to dim a new excel application and set it with CreateObject, but that's *NOT* what I'm wanting to do here and just want to try to be clear on what I'm looking for. I know there must be a way to find the Windows handle and return a workbook name but I haven't been able to figure it out yet....Thanks in advance...Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Show Existing IE Instance if Already Exists, Else Open One | Excel Discussion (Misc queries) | |||
Disassociate existing macro from control key and execute by botton | Excel Discussion (Misc queries) | |||
How do I specify an existing procedure to run from a control adde. | Excel Programming | |||
Get an object representing an existing Excel instance from Outlook | Excel Programming | |||
Taking focus off a Control Checkbox | Excel Programming |