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/showpost.aspx postid=1206503&siteid=1
--
Cheers,
Rama
full file path of running process/instance
laoer
If you are not starting the instance from VB then you may wish to consider getting the Application with getobject and proceeding form there:
Dim
XLApp As xl.Application = GetObject(, "Excel.Application") Dim wb As xl.Workbook = XLApp.Workbooks(1) Dim WorkBookPath As String = wb.Path Dim WorkBookFullPathName As String = wb.FullName MessageBox.Show(WorkBookPath) MessageBox.Show(WorkBookFullPathName)For more info on GetObject see:
http://msdn.microsoft.com/library/default.asp url=/library/en-us/vblr7/html/vafctGetObject.asp
Deepa7476
Hi,
I got the solution in the following link.
http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.excel.programming&mid=8db024f6-20df-4b19-af97-f054cb2e97fb