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

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

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

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

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

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

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

Thisworkbook.fullname


--
bighead


------------------------------------------------------------------------
bighead's Profile: http://www.excelforum.com/member.php...o&userid=27048
View this thread: http://www.excelforum.com/showthread...hreadid=469433