Open file with a specific string in the filename

**vikas.mehta80** · 09-18-2012, 03:45 PM

I am trying to open a specific file from the same folder which contains the macro enabled sheet using the following code:

Workbooks.Open (ThisWorkbook.Path & "\abc xyz_dd_mm_yy.xlsx")

Now, every week the dd_mm_yy section of the file name will change and "abc xyz" portion will remain the same. Is there a way, that I can open any file which contains "abc xyz" in the filename using VBA?

**tigeravatar** · 09-18-2012, 03:50 PM

vikas.mehta80,

Welcome to the forum!
Will there always only be a single file that contains "abc xyz"? Or could there be multiple files? If there are multiple files, do you only want to open the most recent, or all of them?

**vikas.mehta80** · 09-18-2012, 04:31 PM

There will be only one file with the name "abc xyz" in the folder.

**tigeravatar** · 09-18-2012, 04:44 PM

vikas.mehta80,

If there is always only one file, you should be able to adapt the following code. I have provided comments for clarity.

Please Login or Register  to view this content.

**vikas.mehta80** · 09-18-2012, 05:13 PM

Thanks a lot it works fine

**tigeravatar** · 09-18-2012, 05:19 PM

You're very welcome

If that takes care of your need, please mark this thread as solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save