VBA to import all sheets from closed workbook to Active Sheet.

Hi,

Please help me with the code to pull up all the sheet from closed workbook to active opend workbook.

Closed Workbook name : Create Position
Active Workbook name : EIB builder

Please advice,

Thanks,
Shiva

Edit the path and file name on this line " wbNewName = "C:\Users\shelton.ates\Desktop\Create Position.xlsx" in the code below and run the macro with the Active book open.

Please Login or Register  to view this content.