kficso01
04-04-2016, 06:04 PM
Hi all,
I have a task for which I would like to ask for some suggestions. There are two parts this:
Part 1) The files in a folder have date as part of the name of that excel file. Use this naming convention to order the files by date. Once the order is established use it to
Part 2) To open the files one by one and copy their content into one big file. However the order matters in terms which one we open first and second and copy the content sequentially.
I found a couple of suggestions for Part 1) in a form of a function but not sure how to access the list from the function so I could build a loop to pick the files one by one. Essentially I am looking for solutions for the whole task.
Many thanks in advance
I have a task for which I would like to ask for some suggestions. There are two parts this:
Part 1) The files in a folder have date as part of the name of that excel file. Use this naming convention to order the files by date. Once the order is established use it to
Part 2) To open the files one by one and copy their content into one big file. However the order matters in terms which one we open first and second and copy the content sequentially.
I found a couple of suggestions for Part 1) in a form of a function but not sure how to access the list from the function so I could build a loop to pick the files one by one. Essentially I am looking for solutions for the whole task.
Many thanks in advance