Select and Open files from a Listbox - Problems

[kcspringer]

I just purchased the Holy Macro! CD and I'm having a problem with 01989v.xls which is to "Select and open Files from a ListBox (XL8)".

The command button one which opens the file listing doesn't work.

Do you have any suggestions? Thanks.

Kevin Springer.

 

[Juan Pablo González]

It works correctly for me. But, you must modify the code to look in the folder that you want... as it is written, it will look for files in the folder where Excel is installed, where is very likely that it won't find any files.

You need to change the line

    ExePath = Application.Path

that is in the Initialize event of the Userform, for something like

    ExePath = "C:\My Documents"