creating .bmp file from 'OLE Object' field

[MartinF]

Hi there,

Please could anyone tell me how i can save an 'OLE object' bitmap image from a table into a .bmp file.

Thanks in advance

 

[BillPower]

Hi MartinF,

You should be able to just double-click on the Ole Object in the Table.

MS Paint or other Associated Package should open.

Save As desired Image name.

Bill

 

[MartinF]

Hi Bill,

thanks for your response, unfortunately, what i neglected to specify is that i want to be able to do it from VBA.

Any more ideas?

 

[BillPower]

Hi Martin,

I have posted an example of how you can open the application associated with your OLE object. All the user has to do is select from the menu File>> Save As.

The file to look at is Insert Ole Object Using a Common Dialog Control.zip at

http://www.wpower.fsbusiness.co.uk/

The button to press is Save OLE Object to a File.

I've got a feeling this is as close as you are going to get to your question.

I did try using the SendKeys method to get the Save As dialog box to come up. But unfortuneately it doesn't work every time.

Bill

 

[slebans]

For the ability to programmatically save the contents of the OLE field to a disk based Bitmap or Jpeg file see:

http://www.lebans.com/oletodisk.htm

HTH
Stephen Lebans