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

Unable to copy and paste between 2 instances of Excel
 

Within Excel, excel manages the copying. Excel is smart enough to enhance
capabilities. Outside, it is one application going to another application.
the fact that they are the same is of little consequence.

--
Regards,
Tom Ogilvy


"ANeelima" wrote:

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

Unable to copy and paste between 2 instances of Excel
 

Thanks.
So, let me clarify the answer. So, you are saying that even though I am
copying from one Excel instance to another Excel instance, the chart will not
get copied because it is still another application??

Has this been fixed in Excel 2003 or is there any patch for this?
--
ANeelima


"Tom Ogilvy" wrote:

Within Excel, excel manages the copying. Excel is smart enough to enhance
capabilities. Outside, it is one application going to another application.
the fact that they are the same is of little consequence.

--
Regards,
Tom Ogilvy


"ANeelima" wrote:

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

Unable to copy and paste between 2 instances of Excel
 

There is nothing to fix or patch.

try copying each part separately.

--
Regards,
Tom Ogilvy



"ANeelima" wrote:

Thanks.
So, let me clarify the answer. So, you are saying that even though I am
copying from one Excel instance to another Excel instance, the chart will not
get copied because it is still another application??

Has this been fixed in Excel 2003 or is there any patch for this?
--
ANeelima


"Tom Ogilvy" wrote:

Within Excel, excel manages the copying. Excel is smart enough to enhance
capabilities. Outside, it is one application going to another application.
the fact that they are the same is of little consequence.

--
Regards,
Tom Ogilvy


"ANeelima" wrote:

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