Unable to copy and paste between 2 instances of Excel
Hello,
I am currently using Excel 2002 sp3.
1) I launched an instance of Excel, opened an exising workbook containing
some sample data and a chart.
2) I then launched a second instance of Excel
3) I copied all the contents of the sheet from the first instance of Excel
(including the data and chart) and tried to paste them into a second instance
of Excel.
I noticed that only the data gets pasted but not the chart. Now, if I copy
and paste between workbooks in the same instance, the chart also gets pasted.
So, the question is, is this working as designed or an Excel bug? If so, is
there any way to get this to work?
The reason I am asking is because we have a VB6 application that hosts the
Microsoft DSO Framer control. The DSO Framer control allows the user to open
an Excel workbook. Similarly I followed the below steps
1) I launched my VB6 application and opened an Excel workbook
2) I then launched an external instance of Excel outside of the application,
copied the data and chart and attempted to paste them into the excel instance
within my application.
3) Only the data keeps getting pasted.
The only way for me to paste the chart as well is using Paste Special. Is
there any explanation to this? Thanks!
--
ANeelima
|