Thread: How to determine full path of table by a macro within it
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rowan[_9_] Rowan[_9_] is offline
external usenet poster
  
Posts: 88
Default 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
Reply With QuoteReply With Quote