View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default How to find out the path to excel.exe thru vb

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