How to get path of ThisWorkBook

[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.

 

[Ron Rosenfeld]

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.

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

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


--ron