Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
only the macro name and not the full path to show in the run box | Excel Discussion (Misc queries) | |||
Full path possible to be seen? | New Users to Excel | |||
Full path in title bar | Excel Discussion (Misc queries) | |||
Full path in taskbar | Excel Programming | |||
How to get the full path name of the open workbook in a macro | Excel Programming |