Unable to Copy and Paste

I have an Excel Application that works as expected. However, I am unable to
copy and paste data into another workbook. I thoughts as to what's causing
this?

Are you running any code in the workbooks? Code can clear the clipboard.
other than that are you working with two workbooks in one instance of Excel
or are you working with two instances of Excel? That will cause some
difficulties with copy and paste...
--
HTH...

Jim Thomlinson


"Keith" wrote:

> I have an Excel Application that works as expected. However, I am unable to
> copy and paste data into another workbook. I thoughts as to what's causing
> this?

Are you running any code in the workbooks? Code can clear the clipboard.
other than that are you working with two workbooks in one instance of Excel
or are you working with two instances of Excel? That will cause some
difficulties with copy and paste...
--
HTH...

Jim Thomlinson


"Keith" wrote:

> I have an Excel Application that works as expected. However, I am unable to
> copy and paste data into another workbook. I thoughts as to what's causing
> this?

I'm trying to copy values from one workbook that contains code, to a new
workbook that does not contain code. Both workbooks in one instance of Excel.

I did not included code to clear the clipboard, but perhaps some of my code
is causing this un-intentionally. Can you identify code that could cause this?

"Jim Thomlinson" wrote:

> Are you running any code in the workbooks? Code can clear the clipboard.
> other than that are you working with two workbooks in one instance of Excel
> or are you working with two instances of Excel? That will cause some
> difficulties with copy and paste...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Keith" wrote:
>
> > I have an Excel Application that works as expected. However, I am unable to
> > copy and paste data into another workbook. I thoughts as to what's causing
> > this?

Selection change event code would be the most likely culprit. Otherwise look
at worksheet activate deactivate code... Activating code will clear the copy
area of a spreadsheet.
--
HTH...

Jim Thomlinson


"Keith" wrote:

> I'm trying to copy values from one workbook that contains code, to a new
> workbook that does not contain code. Both workbooks in one instance of Excel.
>
> I did not included code to clear the clipboard, but perhaps some of my code
> is causing this un-intentionally. Can you identify code that could cause this?
>
> "Jim Thomlinson" wrote:
>
> > Are you running any code in the workbooks? Code can clear the clipboard.
> > other than that are you working with two workbooks in one instance of Excel
> > or are you working with two instances of Excel? That will cause some
> > difficulties with copy and paste...
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "Keith" wrote:
> >
> > > I have an Excel Application that works as expected. However, I am unable to
> > > copy and paste data into another workbook. I thoughts as to what's causing
> > > this?

You right! Since I hide the formula bar on certain sheets, the workbook
deactivate uses Application.DisplayFormulaBar to show the formula bar on the
newly active workbook. It is this action that must be preventing the paste
feature on the Edit menu. However, if Office clipboard is open, then this is
not the case and the values are available for pasting. Odd?

Thanks for your help!

"Jim Thomlinson" wrote:

> Selection change event code would be the most likely culprit. Otherwise look
> at worksheet activate deactivate code... Activating code will clear the copy
> area of a spreadsheet.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Keith" wrote:
>
> > I'm trying to copy values from one workbook that contains code, to a new
> > workbook that does not contain code. Both workbooks in one instance of Excel.
> >
> > I did not included code to clear the clipboard, but perhaps some of my code
> > is causing this un-intentionally. Can you identify code that could cause this?
> >
> > "Jim Thomlinson" wrote:
> >
> > > Are you running any code in the workbooks? Code can clear the clipboard.
> > > other than that are you working with two workbooks in one instance of Excel
> > > or are you working with two instances of Excel? That will cause some
> > > difficulties with copy and paste...
> > > --
> > > HTH...
> > >
> > > Jim Thomlinson
> > >
> > >
> > > "Keith" wrote:
> > >
> > > > I have an Excel Application that works as expected. However, I am unable to
> > > > copy and paste data into another workbook. I thoughts as to what's causing
> > > > this?