filefilter in Excel VBA not working as I want
Posted on 2014-09-25
I have the following line in my VBA code in Excel 2010
rnl_fname = Application.GetOpenFilename(Title:="Select R560 Renewal SUM", _
When the file dialog box comes up, I only want it to show files that start with R560Combined and end in .SUM. For instance I might have a R560CombinedARD.SUM and a R560ARD.SUM. I only want to see the COMBINED one in my file open dialog. I've tried putting the R560Combined in front of both *.sum and that doesn't work. if I put it in front of the first *.sum, then it defaults to *.* basically and doesn't use my filter. Any ideas on how I can make this work?