View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
R. Choate R. Choate is offline
external usenet poster
 
Posts: 106
Default 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