Forum Discussion
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 ...
Are you running this code while the same worksheet is active as last time? If yes, what happens if you right-click cell A1 (assuming it contains an existing import) and choose Refresh?