Hi,

I want to insert any type of object (ie. .doc, .pdf, etc) into a boundedOLE object (inside a VBA form)

I found it useful to use the insert object dialog box:

OLEobject.Action = acOLEInsertObjDlg

this will bring up the browse box, where i select the object and it will insert it into the OLE frame.

However this did not fullfil the requirements, i need the ability to drag an object from an external window (ie. explorer) and drop it on the object where it will insert the object (just like with the insert object dialog box)

However after research i found that if i want to use the OLE drag and drop OLEObject to do this (shown in the link below) the file formats are very limited to .bmp, text, ewf, mwf, .......

http://msdn.microsoft.com/library/de...ledragdrop.asp

But if i can insert an object through the insert object dialog so easily i should be able to insert an object through drag and drop.

Thanks in advance for your help.