View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Get path to current workbook

Hi Robert,

Dim strpath As String
strpath = ThisWorkbook.Path

--
Regards,

OssieMac


"Robert Crandal" wrote:

If I have a workbook that can be copied to and used in any
arbitrary folder, that means each workbook will have
a different path.

Is there a way to determine the path of a workbook??
(Or path of "ThisWorkbook")

Thank you!


.