Excel Visual Basics - Reading Closed .csv files & Grabbing Certain Rows

Hello everyone, I am pretty new to using VBA and was hoping someone could help me with retrieving certain information from file(s). At this moment I am trying to get Excel to read and grab informat...