Export OLE

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top