VBA code possible to extract values from .CSV files?

Hello,

I have the following code (below) that navigates me to a folder containing a set of .CSV files. I target two values (present in the same cells in each file) to append to the Active Workbook I'm running the code from. I thought I had an issue working accessing files stored on OneDrive, but that wasn't the issue. If I try to access the target values from the .CSV files, I get a '#REF!' error. However, if I run a script that changes the .CSV file format to .XLSM format, I can run this code and my target values are populated properly. I can even manually change the file extensions back to .CSV and it still works (I imagine because it is still interpreted as an .XLSM file). I do have code to change all of the original .CSV files over to .XLSM file formats, but it makes other steps in my reporting stream more difficult.

My bottom-line question is: Can the code below be adjusted so that I can successfully grab my target values from the original .CSV files inside the 'Orig_CSV_Rpts' folder (instead of having to first convert them to .XLSM files)? The code below results in '#REF!' errors for the values I'm targeting in 'A14' & 'B14 in each of the .CSV files.

Thank you!

Please Login or Register  to view this content.

Hi Sergio - thank you very much for your response. I'm glad I at least understand why I could not make this code behave while attempting to extract information from .CSV files. I will be converting the files to .XLS* files, as that will ultimately be easier for me to obtain my targeted data rather than messing with these lengthy code examples that I do not understand quite as well. Thank you again!