我建议您SaveAs将工作簿从Excel实例A复制到临时文件，然后在Excel实例B中打开此临时文件以复制工作表你需要.

I suggest you SaveAs your workbook from Excel instance A to a temp file, and then open this temp file in Excel instance B in order to copy the sheet you need.