I am using Visual Basic for Applications (MS Excel), to try to use the code from
But I can't get it to work right at all. The form never loads correctly as programmed. The program doesn't crash, but it doesn't work either. The form will load, but none of the code tagged on with the form populates any of the fields (such as the combo box, or the directory bar). A blank form just loads up. I can put in a location, and type in a filetype, it even appears to run, but nothing ever displays (even if I put *.* in the root drive!) I am beginning to think that either;
a) This code will not work with VBA, and requires VB.net or VB6
b) I am a complete newbie, and have no idea what I am doing.
I have set everything up according to instructions, labeled the form fields properly, and inserted the code correctly (one part in the form code, with the variable definitions in a module). I can't figure it out, and I have tried several pieces of form code too, all with similair results. Some help would be appreciated!