View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jie Wang [MSFT] Jie Wang [MSFT] is offline
external usenet poster
 
Posts: 20
Default How to handle objects drag-drop? (Excel 2007 + VS 2008)

Hi Tomasz,

The following code works on my side:

tvData.DoDragDrop(String.Format("=SayHello(""{0}"" )", item.Text),
DragDropEffects.Copy)

Where SayHello function is defined in VBA.

Drag & drop built-in functions also works:

tvData.DoDragDrop("=TODAY()", DragDropEffects.Copy)

Could you verify the actual string you're sending to drag & drop contains
the correct format of the formular?

Thanks,

Jie