Question: how to copy worksheet to another workbook vba without opening?
Answer: 2 Answers. sht1 and sht2 should be declare as Worksheet . As for updating the workbook without opening it, it can be done but a different approach will be needed. To make it look like you're not opening the workbook, you can turn ScreenUpdating on/off.