How to find out the path to excel.exe thru vb

[sentiboy@gmail.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

[Jim Cone]

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


<sentiboy@gmail.com> wrote in message news:1142795739.399245.46460@e56g2000cwe.googlegroups.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