use ThisWorkbook.path
here's an example
Option Explicit
Dim FilePath As String
Sub wbPath()
FilePath = ThisWorkbook.Path
MsgBox FilePath
End Sub
--
Gary
"Jazz1934" wrote in message
...
Hello!
I'm programming in VB 6.0. I'm writing a macro in an XLS table. How can I
determine in the program the full path of the table itself, including the
drive letter? Is there a function for it, or any other way?
Thanks,
Viktor