auto select file

My macro, allows me to choose what folder I want to open, and then select a file. It copys and pastes the information I want from the file to my active workbook.

Is there a way to choose what folder you want to open and the macro chooses which file to open, to copy and paste information from, based on a partial title?

The folder is variable so I have to choose it.

for example the files would look like this:

abc1date
abc2date
abc3date

So the partial title would just be "abc1" or "abc2"

this is the code I have right now:

Please Login or Register  to view this content.

https://stackoverflow.com/questions/...rtial-filename

https://www.mrexcel.com/forum/excel-...ile-names.html

Hi, I am still having difficulty. The first code keeps saying, "run time error 424 object required". The second one doesn't seem to work either :/