Open File For Use By Macro

    i want a macro to open a dialog box for the user to path to their file. i then want to continue to run macros on the file they chose. any ideas?

    Re: Opn File For Use By Macro


    Hi


    Try


    Code
    Application.Dialogs(xlDialogFindFile).Show


    This will allow you to open the file and the macro will continue in the file that is opened.


    HTH


    Tony

Participate now!

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

Register Yourself Login