Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Copy and Paste
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Copy and Paste
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Copy and Paste
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Copy and Paste
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lotus Notes - Unable to Copy Paste Special in macro | Excel Worksheet Functions | |||
Unable to copy and paste in excel | Excel Discussion (Misc queries) | |||
Unable to copy / paste acress workbooks | Excel Discussion (Misc queries) | |||
unable to copy/paste in excel once clipboard becomes full | New Users to Excel | |||
Unable to copy/paste in Excel once clipboard gets full | Excel Discussion (Misc queries) |