Runt-time Error 1401 When Importing a CSV file Using VBA

I am beyond frustrated that I cannot make this work. Let me explain. My spreadsheet needs to import a standard CSV file then parse that information into several different worksheets. The very first ...