Posts by Ivan F Moala

    Re: printers list


    Re: GetOpenFilename


    Quote from Elaine

    Is there a way to include a path (S:\A\B\C\D) in GetOpenFilename so users don't have to work their way down to the appropriate directory to select a file?


    Thanks in advance for your help.
    Elaine


    Elaine


    Look up


    ChDrive
    ChDir



    Also remember to restore current Directories back to what they were.

    Re: cancel using escape key


    Quote from Bradford

    I did have that, but the red X pretty much does the same thing. Also that still forces a mouse interaction, vs the desired keystroke.


    Thanks
    Mark


    Mark, have a look @ what Richie says .... if you impliment this you will get the desired result ie Esc will unload the form.

    Re: Updating VBA code if sheet name changes


    Use he Sheets Code name in your code instead.


    Have a look in the VBE > Project explorer .... you will see


    Sheet1(Sheet1)
    Sheet2(Sheet2)


    Names in brackets are Tab sheet names you enter/change
    The 1st name is the code name and does not change unless done
    by code or via the applications screen..... just lock the project for protection.

    Re: check file path/name prior to running a macro


    That was a good start .... have a look @ this.


    For further help highlight the Key words and press F1


    Re: Custom Function Not Working


    It's not working because you are passing arguments to functions that are beyond it's calling scope (Not initailized so = 0)


    eg


    Channel_Bottom * Flow_Depth > channel_Bottom =0 as does all your other variables ... > Division by Zeroe errors


    why not just (


    Re: run a macro on other workbook


    If there is no way you can do what REPO13 suggests then you will need to


    CODE for


    1) Open workbook
    2) call routine like

    Code
    Application.Run "NameOfBook.xls!NameOfRoutine"


    3) Close WorkBook

    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