Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
Can any body tell me how to extract the path of excel.exe installed on my computer thru vb 6.0. by Sentimental |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sentimental,
I don't have classic VB, but this should work... '--------------------------- Sub GetExcelPathFromVB() Dim appXL As Object Dim s As String Set appXL = CreateObject("Excel.Application") s = appXL.Path MsgBox s appXL.Quit Set appXL = Nothing End Sub '------------ Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware wrote in message ups.com... Hi All, Can any body tell me how to extract the path of excel.exe installed on my computer thru vb 6.0. by Sentimental |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sharing violation on Excel files and cannot find the path specifie | Excel Discussion (Misc queries) | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
Find Excel path | Excel Programming | |||
find a path | Excel Programming |