Thread
:
Taking control of an existing instance of Excel
View Single Post
#
4
Posted to microsoft.public.excel.programming
R. Choate
external usenet poster
Posts: 106
Taking control of an existing instance of Excel
You're right, he did set his clock. What a jerk.
--
RMC,CPA
"Don Guillett" wrote in message ...
You probably didn't intentionally set your clock to keep you at the top of
the list, did you?
--
Don Guillett
SalesAid Software
"nmventure" wrote in message
...
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
Reply With Quote
R. Choate
View Public Profile
Find all posts by R. Choate