I have a spreadsheet with 25000 ish cells in column A each containing a complete directory path to a file I want to read (all .txt files). There are multiple folders and files, but all have an exact reference in the cell in column A.
How can I get these files to automatically read in and put the whole contents next in the column B next to the respective file path?
These files contain linebreaks and I need the macro to ignore the linebreaks so that the whole contents of each file is in a single cell.
Can anyone assist with this?
Thank you
How can I get these files to automatically read in and put the whole contents next in the column B next to the respective file path?
These files contain linebreaks and I need the macro to ignore the linebreaks so that the whole contents of each file is in a single cell.
Can anyone assist with this?
Thank you
