Excel VBA Script = Import Dynamic List of Files, Export Results to Two Folders

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.


Se mere: dynamic file import vba, vba excel dynamic list, vba with, export folder list excel, file2, excel vba with, excel vba and, a6, vba excel macro, Macro vba, macro excel, macro + excel, import two, export from excel, excel/vba, excel vba script, excel vba macro, Excel Macro VBA, excel export cell txt, macro script file

Om arbejdsgiveren:
( 12 bedømmelser ) United States

Projekt ID: #3323328

Tildelt til:


See private message.

$25.5 USD in 14 dage
(188 bedømmelser)

2 freelancere byder i gennemsnit $23 på dette job


See private message.

$21.25 USD in 14 dage
(0 bedømmelser)