List and Open Multiple Files

crafty42

New Member
Joined
Oct 18, 2015
Messages
6
Hello. Been a long time since I've played with VBA. About 7 years going by my last post. I'm looking to make a vba program (it's what I have available) that will use a form and listbox to display a list of files in a folder. From there, I am going to try and filter the files by multiple text box entries. In other words, files that have "0-100" in the name, and then filter those if they have the word "truck" in them, and filter those...on so on. Probably 3-4 searches.

What I'd like to be able to do is select multiple files and open them. As if you shift selected numerous JPG files in windows explorer and hit enter to open them all in an image viewer.

Not looking for anyone to write this all for me, but some points in the directions of the commands and such I'll need would get me going. Thanks! I "think" I can handle most of it, just the multi-select and open might be a challenge.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,223,248
Messages
6,171,027
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top