PDA

View Full Version : Sleeper: Suppress default drag&drop?



alimcpill
03-29-2005, 02:05 AM
Hi,

I'm trying to implement drag and drop into a control on a spreadsheet. I have a ListView* control which supports the OLEDragDrop event, which I need to use to have files dropped from explorer onto the control. If I put the control on a userform this all works fine. The problem is however that when I put a ListView on an actual worksheet and try to drop files on it, excel just deals with it as any other drag drop and attempts to open the file.
Basically I need a way of suppressing the way excel wants to deal with this event and allow the control to handle it. Does anyone know if this is possible?

cheers
Al

*This contorl doesn't appear in the toolbox by default but it's part of Windows Common Controls library (MSCOMCTL.OCX) which should be on most systems already, just need to to right click and add additional controls to the toolbox.