Copy values from multiple closed workbooks to a summary worksheet

[teireii]

Hello all, I am a very fresh hand in VBA with knowledge limited to recording Macro. I am currently working on +100 workbooks in different folder and need to consolidate the data from each workbooks into one consolidation worksheet. All workbooks(questionnaire) are in identical format. The cells I need to copy from each workbook (the answer) are B2, B4, E28, I32:I36, I40:I45 and M26. The cell values are going to be input in horizontal lines and next row will be the next answer received(next workbook). When i search through the internet, i found one impressive source code that almost suit my need. However, i do not know how to get the values of other cells as the code only copy values in a range instead of multiple ranges/ cells. How can i edit the code to suit my need? I welcome any advice with new code.

Source code i google is as per below:

Please Login or Register  to view this content.

Thank you very much!



Moderator's Note:Welcome to the forum. You have to put code tags around codes. Select the codes then hit the "#" sign. I'll do it for you this time. Thank you.

[AlphaFrog]

You could call GetData for each area

Please Login or Register  to view this content.

...etc.


Or alliteratively, you could copy one large area e.g.; B2:M45 to a temporary location and then copy specific values from that temporary location to your specific columns and rows.

[teireii]

Thank you! but it didn't work smooth. It keeps on popping error message.