How to determine full path of table by a macro within it

[Jazz1934]

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

[bighead]

Thisworkbook.fullname

[Rowan]

Have you tried:

thisworkbook.Path
or
Workbooks("Book1.xls").Path

Hope this helps
Rowan

Jazz1934 wrote:
> 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

[Gary Keramidas]

use ThisWorkbook.path

here's an example

Option Explicit
Dim FilePath As String

Sub wbPath()
FilePath = ThisWorkbook.Path
MsgBox FilePath
End Sub

--


Gary


"Jazz1934" <Jazz1934@discussions.microsoft.com> wrote in message
news:1666A392-0F19-428D-A513-16D5B294E5B8@microsoft.com...
> 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