how do you get the name of the file folder that your excel file is in?
J Jacob Skaria Aug 13, 2009 #2 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
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
