browse folder

  • Hello


    I have a macro that will open files in a specified folder, do some calculations on them. The files have name like , exampl1.xls,exampl2.xls....The files may be in say, folder1 or folder2 etc...


    I am looking for a way .... when the macro starts, a dialog box comes up so that I can select the folder where all my example1.xls,example2.xls...resides... then the macro reads all these files..

  • Re: browse folder


    Quote from ljoseph

    Hello


    I have a macro that will open files in a specified folder, do some calculations on them. The files have name like , exampl1.xls,exampl2.xls....The files may be in say, folder1 or folder2 etc...


    I am looking for a way .... when the macro starts, a dialog box comes up so that I can select the folder where all my example1.xls,example2.xls...resides... then the macro reads all these files..


    Hi
    There are a number of ways to do this
    If you use Xl2000 then this may help


    http://www.xcelfiles.com/Shell32_00.html

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!