Hi, this is an amazing tutorial and potentially a life saver for a project I have at work at the moment. Just one problem, I have a folder with about zip folders and I need the file names of the files inside the zip folders. How can I do this?
Very nice trick. It works as intended until I save (macro enabled) and reopen the book. After pasting a new path all I get is a #NAME? in the filename list. What am I missing ? Excel 365 version 2102.
very usefull, but I'm working with a dutch version of excel and can't find this formula. I do have office. I've checked the convert list on www but I can't find this Files formula. Anyone knows the dutch name? thanks
Is there any way that the folder name/path can be changed whenever needed? Like a drop down box or data entry cell to introduce other folder's name/path ( of course one folder at a time?)
Some versions of Excel have dynamic arrays which allow formula results to spill across multiple cells. If you do not have this you will have to use the index formula to get all of the files.
This is legitimately the best Excel tutorial I have ever seen.
Thank you.
Hi, this is an amazing tutorial and potentially a life saver for a project I have at work at the moment. Just one problem, I have a folder with about zip folders and I need the file names of the files inside the zip folders. How can I do this?
concise and simply brilliant explanation! thanks!
This is great. I was using VBA. Super cool.
Thanks for your helpful tutorial, but is there any way to obtain file names from subfolder as well?
Great work. Beautiful automation
Awesome lesson, and very useful for my project. Is there a way to also include sub folders and their respective files?
Thank you so much Karina
Wow, really nicely done! Thanks so much.
Very nice trick. It works as intended until I save (macro enabled) and reopen the book. After pasting a new path all I get is a #NAME? in the filename list. What am I missing ? Excel 365 version 2102.
very usefull, but I'm working with a dutch version of excel and can't find this formula. I do have office. I've checked the convert list on www but I can't find this Files formula. Anyone knows the dutch name? thanks
Is there any way that the folder name/path can be changed whenever needed? Like a drop down box or data entry cell to introduce other folder's name/path ( of course one folder at a time?)
can you get it to do subfolders?
Do you have a mac version for this. done it step by step but get #name? error
I have the same issue. pls help
Thank you very much..
What if i need copy sub folders file name
Super cool.
It only returns the first file name
why?
Some versions of Excel have dynamic arrays which allow formula results to spill across multiple cells. If you do not have this you will have to use the index formula to get all of the files.
@@karinaadcock
Could you send me an example
@@karinaadcock same problem with me also .. cud u please help