Hi, I would want to copy sheet from one excel instance to another using VBA. Can I do it?
A aakumthekar New Member Aug 21, 2014 #1 Hi, I would want to copy sheet from one excel instance to another using VBA. Can I do it?
Luke M Excel Ninja Staff member Aug 21, 2014 #2 Nope. Both workbooks would need to be in the same instance. You can have the VB open the workbook (again) in the first instance, copy the sheet, and then close it, but the point of a separate instance is that they are separate entities.
Nope. Both workbooks would need to be in the same instance. You can have the VB open the workbook (again) in the first instance, copy the sheet, and then close it, but the point of a separate instance is that they are separate entities.