wild character in vba

Hi, I have created macro which suppose to do the index matching, works fine but need to change to work with the with wildcard in the name. Thank you Sub index_reclaims() ' ' index_reclaims Dim w As Workbook For Each w In Application.Workbooks If (w.Name) Like "*Summary*" Then Exit...

I searched and searched for a way to find and open a folder that contains a certain string. The key was HERE, thanks so much to Jerry Sullivan. Beyond that, my problem was, that I needed to find a string in a folder name with one wildcard, then within it, find a sub-folder with another...

in my excel file i have three sheets: "merged_20140620","Sheet1","Sheet2" the name of the first sheet combines name and date and is changed every day. I want to delete the first two sheets. Please help me to define the first sheet without the date. Application.DisplayAlerts = False...

Hello Friends I am trying to search a table using wild character (*) and then delete it. Following is the command that I am using. I can't get the syntax right for the wild character. Could you please look at the following code and correct me? DoCmd.DeleteObject acTable, "*" & "ImportError" &...