Active workbook folder name

[Jasoni]

How can I solve my active workbooks folder name.

I have

Dim awb As Workbook
Dim FileName As String
Set awb = ActiveWorkbook
FileName = awb.FullName


Which gives me sothing like

C:\test\first.xls

I would like to have only the folder name c:\test

FullName option gives me the whole string, is there any other to have the
folder name without making any string calculating.

 

[papou]

Hello
Thisworkbook.Path

HTH
Cordially
Pascal

 

[Jasoni]

Thank you for the quick answer.
Should have guessed that ;o)