Excel VBA Script = Import Dynamic List of Files, Export Results to Two Folders
$25-30 USD
Paid on delivery
Hi, this is a small VBA script for excel. Must be put into an excel sheet as a macro.
Excel sheet will be placed in folder with set file names: [url removed, login to view], [url removed, login to view], [url removed, login to view] etc... There may be any number of files.
Script will import all the text from the files into a single sheet. Like a normal text import, each paragraph will represent a cell. Thus, if [url removed, login to view] has 3 paragraphs, cell a1,a2,a3 would be filled with values. The paragraphs from file2 will be placed UNDER the first import. So if it has 3 paragraphs it will encompass cell a4,a5,a6. After the import, the data will be exported as text files into two folders of names Type1 and Type2; thus there will be two copies. The file names will be determined and identical to the sheet name. The resulting texts will still have each paragraph treated as a paragraph.
Project ID: #3323328