Very good day to all.

In my situation, I have multiple workbook that located in C directory.
Each these workbook have 1 form that stored a various employee data. It is means, 1 form for 1 employee.

I also have another workbook that called REPORT (my system database) which is stored all employee data inside here. When I open the report, it will auto saved data into this database. All the required data need to be saved by automatically.

My problem here is, inside all these form from multiple closed workbook have the object in various format (JPEG, WORD,TXT, PDF). I need to retrieve all the object inside there and paste it into REPORT. Can anybody show me some guide how to solve this problem using vba code.

Thank and best regards,
-nia-