How to get path of ThisWorkBook

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

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.
Click to expand...


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

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


--ron
 
Top