Excel Worksheet as OLE object

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul3rd - 28 Sep 2007 17:11 GMT

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 to this Message

AnandaSim - 29 Sep 2007 04:20 GMT

I guess you know that storing OLE objects in Access causes a lot of
bloat of the Access file?

You may have come up against an OLE object limitation - that the
clipboard does not persist across closing the object in one record and
opening another object in another record.

You have Excel running with a blank worksheet alongside Access, paste
into that temporary worksheet, switch record, then copy from that
temporary worksheet and paste into the next record.

I normally keep my Excel workbooks outside Access on the file system,
record the full filename and have a button that launches the workbook
based on the full filename in the Access record.

HTH
Ananda

Reply to this Message

Paul3rd - 03 Oct 2007 18:49 GMT

Thanks for answering my question. Each of the records in my table
needs it's own worksheet for user input. I'll try to programatically
open a blank worksheet outside of Access when the user clicks on the current
worksheet.
Paul

> I guess you know that storing OLE objects in Access causes a lot of
> bloat of the Access file?
[quoted text clipped - 13 lines]
> HTH
> Ananda

Reply to this Message