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.
Bookmarks