copy specific cells from multiple .xlsx files into a table in destination file

I have multiple .xlsx files, and I want to copy specific cells on column M from each file and combine them into one table on a destination file “gettotals.xlsm”

I have attached copies of sample .xlsx files as well as the “gettotals.xlsm”

My codes are as follows:

Please Login or Register  to view this content.

The macro ran into error at line “Workbooks.Open (Filepath & MyFile) and I have no clue how to fix the bug.

Shall appreciate if someone can help me make this macro work.

Thank you very much!
Henry

Dear AlphaFrog

The code works perfectly standalone. Thank you very much.

I started with a bunch of raw csv files, which I used a separate macro to trim some columns, rename some headers, do some calculations, etc, and finally came up with the .xlsx files which your code was run against. This means I have to run 2 macros now to get my final file.

Codes for my existing macro is as follows:

Please Login or Register  to view this content.

How do I merge the 2 macros into one? Much appreciate if you could help me out again.

Thanks very much
Henry
[I just started learning vba, so if you could bear with me asking for help. And by the way, can you recommend a good book where I can learn all the basic skills? Thanks]

Thanks for all the help. I am so excited that it is doing exactly what I want it to do. Thanks again