Spreadsheets as OLE objects
 

Hello, I have a table in Access and in each record of that table is an Excel
worksheet embedded as an OLE object. Copy and paste works in the selected
worksheet, but when I try to copy and paste a range of cells from one
embedded worksheet to one in another record the information is not passed to
the clipboard
as I have no paste function.
The worksheets are not linked.
Do the worksheets have to be linked to a workbook outside of Access?
If so, do I then need to programmatically define the path?
Thanks in advance for any help

Spreadsheets as OLE objects
 

Hi Paul3rd,

I've just tried to replicate the situation you describe, and i can't. When i
pasted data from one sheet to a sheet in another record (that is, embedded
within the field of datatype OLE in my sample Access table), the data did in
fact go to the clipboard. Perhaps I have misunderstood? Maybe you have
solved it already, or would you like to re-explain your issue?

cheers, helen


"Paul3rd" wrote:

Hello, I have a table in Access and in each record of that table is an Excel
worksheet embedded as an OLE object. Copy and paste works in the selected
worksheet, but when I try to copy and paste a range of cells from one
embedded worksheet to one in another record the information is not passed to
the clipboard
as I have no paste function.
The worksheets are not linked.
Do the worksheets have to be linked to a workbook outside of Access?
If so, do I then need to programmatically define the path?
Thanks in advance for any help