Excel vba wildcard file search

FileSearch" function has been deprecated from excel Hi, I am trying to set a file name as a string to use it as an attachment. I just need help with the file name Any help is greatly appreciated Thank you. What type of TextBox?

So I changed a few things around. But still have the same problem. So basically I'm trying to do something like Code. Put this into a loop if you have more filenames. By Madhuri Thakur. It is a very good to know feature as it can save a lot of time and effort required to do some research in excel. We will learn about excel wildcard characters in detail in this article. Start Your Free Excel Course.

You can similarly start the search with Asterisk. Question Mark? For Example,? So here, the question mark represents a single character which is M or D. Text, name. Dmitry Pavliv Dmitry Pavliv Match instead loop. See my updated answer — Dmitry Pavliv. Find name. Thierry Dalon Thierry Dalon 5 5 silver badges 20 20 bronze badges.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Replies 16 Views May 3, DanSMT. Question VBA - Opening or getting location for file where I don't know exactly where the file is saved or exactly what it is called. Replies 26 Views Sep 18, GWteB. Question vba search for pdf in folder and subfolders. MM91 Dec 13, Excel Questions.

Replies 1 Views Dec 14, DanteAmor. Question VBA find folders in unknown subfolder whitout searching all subfolders. Ole Madsen Feb 23, Excel Questions. Replies 2 Views Sep 9, MMY. Question Copy multiple sheets from one workbook to multiple files in a folder.