Thread: List files in Folder if Condition is Met
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default List files in Folder if Condition is Met
"Can you point me in the right direction?"

If File.Name Like "*#####.xls" Then
If Val(Right$(File.Name,9)) 5000 Then
'do something
End If
End If
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Filo"
wrote in message
Using VBA, I would like list in column A all of the .xls files included in a
generic folder whose last 5 digits before the .xls extension are greater than
5000.
Can you point me in the right direction?

Thank you.
Filo

Reply With QuoteReply With Quote