PDA

View Full Version : Solved: Copy Tab from close workbook into an open workbook



qcoleman
11-22-2011, 02:58 PM
I’m trying to create code that will take a worksheet from a closed workbook and copy its contents into a new tab in an open workbook, is this possible?

mancubus
11-23-2011, 08:24 AM
look here:
http://www.erlandsendata.no/english/index.php?d=envbadacimportwbado

Aflatoon
11-23-2011, 09:38 AM
Could you not simply open the workbook and copy the sheet to the destination workbook?