I'm trying to automate the import of standardized info on one sheet of several different types of input forms. I've standardized the data I need onto a single sheet, and have a macro that will import it from a known spread sheet, but is there a way to invoke the open dialog box with out having it carry out it's open proceedure so I can collect the file name and directory to use in my macro? I used to know how, but I'm about 5 years rusty, and that was office 95.