FileNames in folder to Cells with Macro

[windzz]

I wonder if there is a macro, which can search and fill in collums by file extention in a selected folder and subfolders of the selected folder?
In this case, it lists all Solidworks Filenames in 1st collumn, and in 2nd and 3rd collumn it fills .pdf and .dxf extention names of files that have at least part of FileName in their names?

Screenshot_1.jpg

Screenshot_2.jpg

[vba_php]

more than likely, the answer here will be all you need:

https://www.excelforum.com/excel-pro...-a-column.html

[windzz]

So I managed to edit your code and get the names from the folder!
The problem is , I don't know how to paste these FileNames to Worksheet cells.

Like fill all filename into Worksheet MAIN Range("A1").
Maybe you have an idea?

Please Login or Register  to view this content.

Untitled.jpg

[vba_php]

Like fill all filename into Worksheet MAIN Range("A1").

LOL. hey! pretty close! try this instead?

Please Login or Register  to view this content.

rules for that code to work:

• code must be behind the sheet you want the file name to go in, OR:
• code in a standard module and the active sheet be the target sheet to get the data
• all filenames are thrown into column A only
• first filename thrown to row 2, and every other filename thrown down each row, one by one downward, until no more files found
• you want file names to start being thrown into cell ''A2''

this will obviously have to be changed when you run it. but I'm sure you can change it to get what you want, if you could take my original and get as far as you did.

[vba_php]

and by the way, if you want to learn something else, you actually touched a very common subject in the programming world with your attempt as pseudo code:

this:

Please Login or Register  to view this content.

is hugely popular is sophisticated languages. along with what is known as a VOID. way beyond VBA. that word actually plays a key role in programs booting up in C#, Java, and a few other languages. so there ya go, something to think about when you become a genius and take your boss's job away.