MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I launch a file open dialog box from within a macro?


Posted by Paul N on January 03, 2002 6:58 AM

I have a spreadsheet that I want to use to analyze data that is generated from other spreadsheets. I hope to be able to set it up so that at the click of a button on my main workbook, I'll be able to get the file open dialog box, select the file, then my macro will do the rest... Any help would be AWESOME!

Thanks

Paul


Posted by Guildenstern on January 03, 2002 7:23 AM

Application.Dialogs(xlDialogOpen).Show