Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
____ Return file path via APIs !!!!
Hi there,
How can I get from XL the path of an open Document in Word without using Automation ? (Maybe through APIs) Regards. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
____ Return file path via APIs !!!!
Sub WDTest()
Dim WD As Object Set WD = GetObject(, "Word.Application") MsgBox WD.ActiveDocument.Path Set WD = Nothing End Sub -- Regards, Tom Ogilvy "RAFAAJ2000" wrote in message ... Hi there, How can I get from XL the path of an open Document in Word without using Automation ? (Maybe through APIs) Regards. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
____ Return file path via APIs !!!!
Dear Tom,
As I mentioned in my post , I don't want to use Automation. I am looking for an alternative solution. The reason I don't want automation is because I want to extend this to other applications that don't necessarly support Automation. Also, if I wanted to retrieve the file path of the active workbook opened in a second Excel instance the GetObject function wouldn't work . Any idea about an alternative to Automation (ie GetObject function) ? There's got to be an API solution to this . Regards. "Tom Ogilvy" wrote: Sub WDTest() Dim WD As Object Set WD = GetObject(, "Word.Application") MsgBox WD.ActiveDocument.Path Set WD = Nothing End Sub -- Regards, Tom Ogilvy "RAFAAJ2000" wrote in message ... Hi there, How can I get from XL the path of an open Document in Word without using Automation ? (Maybe through APIs) Regards. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
____ Return file path via APIs !!!!
Hi,
This is VB6. It should run with a little modification. Zipfile is at the bottom of the page. http://vb.mvps.org/samples/project.asp?id=TaskList -- John johnf202 at hot mail dot com "RAFAAJ2000" wrote in message ... Dear Tom, As I mentioned in my post , I don't want to use Automation. I am looking for an alternative solution. The reason I don't want automation is because I want to extend this to other applications that don't necessarly support Automation. Also, if I wanted to retrieve the file path of the active workbook opened in a second Excel instance the GetObject function wouldn't work . Any idea about an alternative to Automation (ie GetObject function) ? There's got to be an API solution to this . Regards. "Tom Ogilvy" wrote: Sub WDTest() Dim WD As Object Set WD = GetObject(, "Word.Application") MsgBox WD.ActiveDocument.Path Set WD = Nothing End Sub -- Regards, Tom Ogilvy "RAFAAJ2000" wrote in message ... Hi there, How can I get from XL the path of an open Document in Word without using Automation ? (Maybe through APIs) Regards. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Dialog Box to return Selected File Path and Not Open it. | Excel Programming | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
Recursive Function + File searching to return path | Excel Programming | |||
Return file from a path string | Excel Programming | |||
Return file from a path string | Excel Programming |