name of file folder

  • Thread starter Thread starter dstiefe
  • Start date Start date
D

dstiefe

how do you get the name of the file folder that your excel file is in?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine name of macro contained in each excel file in a folder 9
Import 4 Different Excel Files from One Folder 0
How to find sheet names without opening files 13
Assign buttons on QAT 3
User select folder name 1
VBA Macro - Loop through folder and move files to other folders 8
Macro to open file 2
find newest file in all sub folders 1

Back
Top