Hi everyone!

I'm looking to make a new macro to extract all BOM's from a folder.

So I started looking for a way to populate a list of all drawings from a specific

folder and subfolders.

I found this which got me started but it only lists files and folders.

​

After I will add a button to open all selected files, and then I would extract all the BOM's

in a single excel file. All the BOM's would need to be on different sheets...

For now, I would need help with having all the drawings listed and being able to select

the ones I need to open.

Thanks for any help!

Kevin Chisholm