I am a beginner to Excel and VBA, can somebody show me a few lines of scripts and instructions how to use VBA scripts to combine multiple Excel xls Files (which contain three worksheet) into a single Excel file.
Note:
All Excel files are stored in same folder.
Can somebody also suggest a good book with examples I can start to learn to solve these kinds of problems?
Thanks very much
Note:
All Excel files are stored in same folder.
Can somebody also suggest a good book with examples I can start to learn to solve these kinds of problems?
Thanks very much