ExcelBanter - name of file folder

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - name of file folder (https://www.excelbanter.com/excel-programming/432367-name-file-folder.html)

dstiefe

name of file folder

how do you get the name of the file folder that your excel file is in?

Jacob Skaria

name of file folder

If the opened files are saved

Thisworkbook.Path
'will return the path of the current workbook(where the macro is placed)

Activeworkbook.Path
'will retun the path of active workbook

If this post helps click Yes
---------------
Jacob Skaria

"dstiefe" wrote:

how do you get the name of the file folder that your excel file is in?

All times are GMT +1. The time now is 12:15 PM.