Hi!
I don't know how to make this, but I have weird ide to use 'DoVerb' methid of ole container object. Put it hidden on some form or screen and bind to your general field. Use OLEControl1.DoVerb('Copy')
I hope this will work.
>Hello friends ,
>
>Thats my question, a clean solution to push the contend of a General field into excel. My General filed is loaded with a .Bmp image....
>I've no problem to get the contend of clip board(.bmp) and insert it into excel (via ole automation), in this case, i call a small VBA procedure like this:
>"
>Public Sub Teechart_add(SheetName, ChartNo, ScaleFactor)
> ThisWorkbook.Sheets(SheetName).Range("B6").Select
> ThisWorkbook.Sheets(SheetName).PasteSpecial Format:="Bitmap", Link:=False, DisplayAsIcon:= _
> False
> Selection.ShapeRange.Left = 5
> Selection.ShapeRange.Top = 40 + (ChartNo - 1) * 215
> Selection.ShapeRange.Height = 210 * ScaleFactor
> Selection.ShapeRange.Width = 460 * ScaleFactor
>End Sub
>"
>
>If it is possible to get the contend of my general field into the clipboard(.bmp image)?
>
>HeuHeu, thank you for your attention,
>PHILIPPE
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.