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
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
Thisworkbook.fullname
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
use ThisWorkbook.path
here's an example
Option Explicit
Dim FilePath As String
Sub wbPath()
FilePath = ThisWorkbook.Path
MsgBox FilePath
End Sub
--
Gary
"Jazz1934" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks