combine multiple excel file in to one excel file and multiple worksheet

[jbhoop]

I am wanting to use the following code to combine worksheets from
multiple files. However I would like to be able to select folder which

contains files in a more automated way that having to change the code
every time, and also copy all worksheets with links and formulas
removed. Any help on this is greatly appreciated as I have limited
code knowledge.


Sub Copy_them()

 

[NUMBnut]

You may do a paste special, which will allow you paste only the information
you want. Choose paste values if all you want is the text to be pasted.