Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set objects not to scroll | Excel Discussion (Misc queries) | |||
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
Embedded objects | Excel Discussion (Misc queries) | |||
Insertion of *Objects* Into Spreadsheets (Version Differences) | Excel Discussion (Misc queries) | |||
VBA Objects | Excel Discussion (Misc queries) |