Add data from multiple workbooks that are open and save it in a new workbook

Dear All,

I am new to this forum and Excel VBA probramming. What i am trying to achieve is add data from multiple open workbooks and save it in a new workbook. I am trying to acheive this with the following code but i get stuck when the code reaches "For Each Wk In Wks
Sheets("Self Assessment").Activate". Please help


Code

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here