I want to use a oleDragDrop in an Excel VBA Userform

Hello,

I am fairly new to VBA and macro programming. I would like to devise a
macro that processes a bunch of workbooks. I would like to create a
userform such that I can drag and drop workbooks from windows explorer
into a listbox to determine which files I would like to process.

I found tons of examples online of how to devise a VBA program to
accept "drag and dropped" files from windows explorer, however when I
try to do this from within an excel vba program, I find that the
listbox is slightly different and does not contain the odeDragDrop
functionality.

Is there some kind of library or something I need to import into my
excel vba program? I hope I am making some sense... please help!

.

Relevant Pages

  • adding a code to a cell?
    ... H alli, ... I'm trying to devise a way to do the following... ... Any thoughts on how to achieve this either through VBA or a cell formula? ...
    (microsoft.public.excel.programming)
  • Re:
    ... Thanks once again Cush, ... I think I understand now much better what's going on with all this VBA ... > Dim Dest as Range ... > Then you can start specifying the Sheets and workbooks, ...
    (microsoft.public.excel.programming)
  • Re: password in VBA
    ... The problem Dave, because in the Ron's example, Getopenfile alrready ... determinded the workbooks path, how can we make the password VBA fit with ... Then open the link for "Open method as it applies to the Workbooks object." ... VBA of the password itself: ...
    (microsoft.public.excel.programming)
  • Re: password in VBA
    ... Sorry Dave...may be I have language problem, where shall we put this VBA ... Workbooks.Open Filename:= _ ... and there are about 500 workbooks of the project with the ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.programming)
  • Re: Last Row of Data
    ... I have written some codes and use it for vairous workbooks, however, I ... workbooks, they all look fine on Excel, i want to check my copied modules ... I am not sure what I need to do but think if I can write vba to delete all ...
    (microsoft.public.excel.programming)