Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying OLE Objects retrieved from MS Access
Hello all,
I have a MS Query in Excel filtering and retrieving relevant data from MS Access. When the data returns, all BUT the column which refers to a OLE object datatype in Access returns values. What should I set the format in Excel to see the OLE objects dynamically. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying OLE Objects retrieved from MS Access
-----Original Message----- Hello all, I have a MS Query in Excel filtering and retrieving relevant data from MS Access. When the data returns, all BUT the column which refers to a OLE object datatype in Access returns values. What should I set the format in Excel to see the OLE objects dynamically. Thanks . Hmmm, haven't tried this and not sure if it is possible. Although you can imbed or link an OLE object into Excel manually, there is no "Format" for a cell to display an OLE object. The only thing I could think might work would be to use VBA code (with ADO) to build and run your query, then to transfer the resulting values to your worksheet and programatically insert the objects as you go. Complicated, though, and not enough time/space here for getting into details. Email me at kgdcc(NO if you want to pursue this further... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
displaying objects | Excel Discussion (Misc queries) | |||
setting Excel to reference microsoft activex data objects libraryfrom Access | Charts and Charting in Excel | |||
Importing bound objects (bitmaps) from Access to Excel | Excel Discussion (Misc queries) | |||
Displaying Linked and Embeded Objects in Excel | Excel Discussion (Misc queries) | |||
access contains several objects explain the purpose of the four c | Excel Discussion (Misc queries) |