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.

Hello
Thisworkbook.Path

HTH
Cordially
Pascal

"Jasoni" <(E-Mail Removed)> a écrit dans le message de news:
48e47b5d$0$23611$(E-Mail Removed)...
> 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.
>
>
>

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


"papou" <(E-Mail Removed)> kirjoitti
viestissä:(E-Mail Removed)...
> Hello
> Thisworkbook.Path
>
> HTH
> Cordially
> Pascal
>
> "Jasoni" <(E-Mail Removed)> a écrit dans le message de news:
> 48e47b5d$0$23611$(E-Mail Removed)...
>> 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.
>>
>>
>>
>
>