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?