Extract OLE object containg images using VBscript

Question

An OLE Object column contains images but the image type (jpg/gif/tiff) is unknown. These images need to be extracted from the DB and saved to disk using VBscirpt.

Answer 1

I've done this before in Delphi, the solution was to use the clipboard (somehow the clipboard can determine the type of image). Copy the contents of the field to the clipboard and then save the contents of the clipboard to a file.

Answer 2

Thaks for your response. As per your advice, it possible to do this using clipboard objec, however VBscript does not support Clipboard object. Still I came to know that something can be done using IE/html object.

Now the problem is how we can copy ole Image object to clipboard and then save contents of clipboard as file on local machine atleast using IE object.

Please suggest me your views ASAP.

Thanks inadvance, Satya

Answer 3

Here I found an example to take a screenshot with VBScript and paste it to MS Paint. Maybe you can modify it to do what you want?

http://hisudhakar.spaces.live.com/blog/cns!8DDF980C45482279!410.entry?sa=948299040