like expression

Hello all, I'm trying to create a filter so that i can delete anything that contains "Atv", "Utv", "Duallie", and "Dually" Issues arise when those phrases are sometimes capitalized, sometimes capslocked, and sometimes lowercase. This is my first attempt with filters in VBA which does the job...

I am trying to set a query in Excel from Data\From Other Sources\From Microsoft Query - I am able to get the base data to load fine. The issue becomes when I am setting a parameter based on a Cell value. In this case C5. The cell has valid data in it. If I hard code 'SIR%' I get results...

I've been at this for hours with google sending me to obsolete and older code that no longer works for office 2013. *sigh :mad: Ok, so I have a simple request. I need to look in Dir$("P:\path"), find most recent file of "Internal-EOM-201*" & ".xlsx", open it and define it for later reference...

hi, I have macro where I'm opening workbooks and for diffrent sheets I want to run code. ... Set wb = Workbooks.Open(strPath2 & strFile2) Dim myArray() As String Dim myCount, NumShts As Integer NumShts = wb.Worksheets.Count ReDim myArray(1 To NumShts) For myCount = 1...

Here is part of the codes. I want to use the statements to check if the email subject matches to any of the subjects saved in column K. It can execute without problem. However, email subject can vary from time to time, but still it should contains some key words unchanged. So I tried to use Like...