Excel VBA - Bulk Import .txt from folder, Merge, Export - List of Folders listed in Cells
$30-100 USD
Pago na entrega
Excel VBA Macro
I will have a list of folder directory paths ie (C:\Users\hello\Desktop\texfiles) in the first excel sheet, one per row. The script will import all .txt files in the folder, and append the text files. It will be normal import format, where each paragraph fills a single cell. These aggregation will happen in the second sheet. *A clean, full list of paragraphs must occur before export, because code will be added here*. After being aggregated, the results will be saved into a .txt format having the same name as the folder from which the text files were extracted. The fill will be saved in the same location as the spreadsheet. The script will repeat this process for every directory listed on the first sheet, which will be one per row in the A column.
ID do Projeto: #3323971