How to get path of ThisWorkBook

  • Thread starter Thread starter Mili
  • Start date Start date
M

Mili

Hi,

I am trying to display the path of the excel wheet I
am working on using VBA macro.

I am using office 2000.

Thanks

Regards

Mili.
 
Hi,

I am trying to display the path of the excel wheet I
am working on using VBA macro.

I am using office 2000.

Thanks

Regards

Mili.
Click to expand...


Sub workbookpath()
MsgBox ("Workbook Path: " & ThisWorkbook.Path)
End Sub

Of course, the path is undefined until you save the workbook.


--ron
 
Back
Top