Copy all worksheets in a file to an open workbook
Posted on 2011-09-29
I have a workbook open. I want to copy all worksheets from all workbooks (in a folder) to a workbook I am creating (using macro)
I have tried searching here and internet but I feel my problem is unique. This is due to the fact that I am already using a chunk of coding to get all the file in a specific folder and merge them together in a single worksheet (of an opened workbook)
Among this big chunk of coding, I have the following function
1. Function to count the # of files in a folder
2. Function to get file names
3. Function where the files are merged
In which function do you think its the best to do what I require? Or should I write another function that uses #1 & #2 and then copy paste their contents (worksheets) into another opened file?
Thanks for your input!