Get filename by folders

[atomichybrid]

Hi All,

I had a post show below about file names on cells. This turned our great and is working like a beast for my application.

https://www.excelforum.com/excel-pro...file-code.html

So my question is if I have designated folders that have lower file count I would rather select the folder rather than going inside and select all.
I would want it to write on cell B2 and onwards but if I decided to add more files (from another directory) I would want it to append the end of the list so it doesn't overwrite on Cell B2 and onwards.

You guys are so helpful and I appreciate your feedback.
Cheers

atomichybrid

[bakerman2]

Try this. In the 1st window select the directory you wish to scan.

If filecount < 40 then listing is automatic else filepicker opens.

Please Login or Register  to view this content.

[atomichybrid]

Hi bakerman2,

Your code works for what you've mentioned. I like this creative approach if it has less than 40 files then it will add to the list otherwise it will go to file picker.
Though playing around with the VBA, hitting the "Cancel' still continues to the code and hit around,

Please Login or Register  to view this content.

This is assuming if I have not selected anything in case I accidentally clicked the button or something. I think there is a work around to make it say something like you clicked cancel so it doesnt scare the user that an error code had happened, I remember seeing some kind of video for this but I'm not sure if its implementable.

Also when the directory is less than 40 the files add but still opens a dialogue of the directory I chose. I assuming after the first 'with' code is complete the VBA continues to run the next 'with' code which is meant for folders exceeding the 40 file limit. Is this correct based on reading your code?

This is pretty good for the early stages of your code.

Please Login or Register  to view this content.

I'm not sure if this part is necessary to scan directories, unless this is the only workaround for file limit scanning. I am quite happy to have the folder only option and create a separate button for the file picker version.

Look forward to your feedback.

atomichybrid

[bakerman2]

My bad, didn't test enough.

Next code should do as expected.

Please Login or Register  to view this content.

PS: you can change 40 to another number more to your liking if you wish.

[atomichybrid]

Hi bakerman2,

Thanks for revising the code and it now works like a beast!
Thanks heaps for your help, this will save me lots of time and processes with this.

I would love to give you more reputation but I seem to get this notice perhaps I gave too much?

"You must spread some Reputation around before giving it to bakerman2 again."

atomichybrid

[bakerman2]

You're welcome and thanks for rep+.