Drag and Drop from Windows Explorer into Userform or Listbox

[Fatchan]

Hello,


I would like to create a macro that processes a bunch of excel files.

To determine which files should be processed, I want to create something like a listbox, into which I can drag files from windows explorer. When I am done adding the files I want to process, I want to iterate through the list of files and operate on them.

Can anyone provide me some help on how to write the code for the listbox?

 

[Fatchan]

I have found a relatively simple way to do this with a form in VB6, does anyone know a way to port from VB6 to VBA?

 

[Norie]

I don't think this will be possible in VBA.

Why not just do the whole thing from VB6?

You can set a reference to the Excel library to access Excel objects/methods/properties.

Or how about using the GetOpenFileName method in VBA?

 

[Fatchan]

Why not just do the whole thing from VB6?

You can set a reference to the Excel library to access Excel objects/methods/properties.

This would be an excellent way to do what I want, can someone show me what I need to do to reference the Excel Library?