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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,215,581
Messages
6,125,656
Members
449,246
Latest member
jbbtz28

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