That looks very good indeed !

Regards,
Peter T

"Rama" wrote in message
...
Hi,
Thanks to all. I found the suitable code in the following link. It
gives
the full path names of all running excel(saved and non saved) instances.

http://www.mrexcel.com/board2/viewto...37277&start=10
--
Cheers,
Rama


"Rama" wrote:

Hi Peter,
Thanks for the reply. How do you get arrXL ??
I know the list of process using Process library in .NET but dont know
what
you are referring to arrXL in the following message. Could you eloborate
bit
futher? I tried to understand the ROT code posted in google forums but
failed.
--
Cheers,
Rama


"Peter T" wrote:

It's not straightforward to find and reference multiple Excel
instances.
If you understand C# (could use in your .Net) a method was described
here -
http://tinyurl.com/yt36s5

In the same thread I briefly described my relatively though not 100%
reliable method to find and reference multiple Excel instances. Having
done
so, for each referenced instance you could do something like this

On Error resume next
For i = 0 to UBound(arrXL) ' array of XL instances
set ws = arrXL(i).Workbooks("abc.xls")
if not ws is nothing then
sFile = ws.Fullname
Exit for

Regards,
Peter T



"Rama" wrote in message
...
Hi ,
Thanks for the reply but the trouble is I can get the instance
full
path(bbc.xls) from Process library as illustarted in the following
link so
I
dont know how to instantiate this excel running instance as I dont
have
full
path.


http://forums.microsoft.com/MSDN/sho...06503&siteid=1



This following line works fine for unsaved excel instances

Set xlObj = VBA.GetObject("Book2").Application

but it fails to create reference whne it uses saved instance.

Set xlObj = VBA.GetObject("bbc").Application

it requires full path to access the currently running instance

Set xlObj = VBA.GetObject("c:\rama\bbc.xls").Application
--
Cheers,
Rama


"John Green" wrote:

ThisWorkbook.FullName

John Green

"Rama" wrote in message
...
Hi Experts,

Can anyone know how to findout the full path(
ex:
c:\rama\bbc.xls) from the curently running instance "bbc.xls". I
dont
mind
accepting VB6\.NET\Windows script solution for the same as i'm
desperate
to
find the full path from ruinng instance. Lets say I've opened
saved
bbc.xls
file and i know the currently opened instances from Process
library
and i
can
get the title("bbc.xls") but i dont know how to get the full
path("c:\rama\bbc.xls")

For more details please have a look at the following link.


http://forums.microsoft.com/MSDN/sho...06503&siteid=1


--
Cheers,
Rama