vba open workbook with certain word in middle of the file name

phairplay

Active Member
Joined
Nov 2, 2011
Messages
260
Hi Guys,

is it possible to open a xls file with only knowing part of the string

I have two file

Custx Fore wk 18 NetChange-Report-A
Custx Firm wk 18 NetChange-Report-A

I want to open the Fore file and work on it and then do the same on the firm. my issue is the Custx string changes so does the Wk 18.

how do I open the file based only on
Fore & Firm

cheers
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

wideboydixon

Well-known Member
Joined
Jun 2, 2016
Messages
3,401
VBA:

Code:
Const sourceFolder = "C:\Users\phairplay\Documents\" ' Change as appropriate
Public Sub OpenPartialFilename(partialMatch As String)

Dim foundFile As String

foundFile = Dir(sourceFolder & "*" & partialMatch & "*.xlsx")
If foundFile <> "" Then Workbooks.Open sourceFolder & foundFile

End Sub
Public Sub OpenFore()

OpenPartialFilename "Fore"

End Sub
Public Sub OpenFirm()

OpenPartialFilename "Firm"

End Sub

WBD
 

Watch MrExcel Video

Forum statistics

Threads
1,109,020
Messages
5,526,296
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top