drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 543
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance!
Imagine I have a Path and a String:
I would like to prompt the user to select any Excel file within the Path = wPath containing the Name = wName
I know How to prompt the user to select within the Folder wPath only excel files , but I do not know how to show only the files containing the name = wName
So if the wPath has 50 Excel Files and only 4 of them containing the string "France"
eg:
When prompting the User only show these Files
Imagine I have a Path and a String:
- wPath = "C:\Users\MrExcel\Desktop\Works"
- wName= "France"
I would like to prompt the user to select any Excel file within the Path = wPath containing the Name = wName
I know How to prompt the user to select within the Folder wPath only excel files , but I do not know how to show only the files containing the name = wName
So if the wPath has 50 Excel Files and only 4 of them containing the string "France"
eg:
- "2018-08-05 France Sales"
- "2018-10-11 France Customers"
- "Sales from France"
- "customers in France"
When prompting the User only show these Files