Export OLE

[Martin]

Hello,

I have a button on a form that exports various queries to a pre-built Excel
file that has links and formats just the way I want it. The code I use is:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Report Map",
DestinationFile, True

This particular code does not work becuase "Report Map" is a query returning
just one column which is an OLE object (a bitmap, not linked).

Is there a way to transfer this OLE object to Excel programatically?

All that transfers is the text stating it is a bitmap object.

Many thanks for your help.

Martin

 

[Alex Dybenko]

Hi,
I think you can try to use this code to extract picture from OLE field:
http://www.lebans.com/oletodisk.htm

and then use automation to insert this extracted picture into excel

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com