ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Embedding an OLE Object from DAO Recordset (https://www.excelbanter.com/excel-programming/412671-embedding-ole-object-dao-recordset.html)

Terri

Embedding an OLE Object from DAO Recordset
 
I am populating an Excel worksheet via code, reading data from an Access
database using a DAO recordset. The recordset contains an OLE Object with a
stored bitmap. The OleObjects.Add method seems only to link or embed an
external file. Is there any way to add an (embedded) OleObject to the
worksheet and set the source to my recordset value?

Any insight would be much appreciated!
---
terri


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com