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