How to create a macro to open different workbooks

[Closed]
Report
Posts
3
Registration date
Saturday March 24, 2018
Status
Member
Last seen
March 24, 2018
-
Hello,

I have around 45-50 excel workbook with 3-5 sheets in each workbook.

Each workbook is named as different unique number such as 823456,823731...etc. All the excel sheets inside workbook is named as same as VOR, Customer Copy, etc..

I want to create a macro which will help me to open each workbook and will copy figures and paste in another excel workbook.

Is it possible!? What details we need more !!!