| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active workbook folder name
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active workbook folder name
Hello
Thisworkbook.Path HTH Cordially Pascal "Jasoni" a écrit dans le message de news: ... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active workbook folder name
Thank you for the quick answer.
Should have guessed that ;o) "papou" kirjoitti ... Hello Thisworkbook.Path HTH Cordially Pascal "Jasoni" a écrit dans le message de news: ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to update active workbook in one folder | Excel Worksheet Functions | |||
| Move Active Workbook to another Folder | Excel Discussion (Misc queries) | |||
| Closing Hidden Workbook when Active Workbook is Closed | Excel Programming | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
| Preventing opening workbook inside active workbook. | Excel Programming | |||
Linear Mode
