I need help trying to import only files with a given extension. I dont
need to consider the text string that comes before the extension. For
example: I have a file named 1GC18950.057, but I only want to look at
the .057 for this file in a known folder. How do I change the code
below to only look for the extension and not the text string before it.
Any help will be GREATLY appreciated!!

With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:\Documents and
Settings\Kevin\Desktop\data\1GC18950.057",