Hi.. did you ever get an answer for this? I'm wanting to do the same thing.
P Pavel Romashkin Oct 2, 2003 #2 Take a look at the FileDialog object. FileDialog is available via Appilcation in your VBA code: Dim fd as FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) fd.show etc. Cheers, Pavel
Take a look at the FileDialog object. FileDialog is available via Appilcation in your VBA code: Dim fd as FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) fd.show etc. Cheers, Pavel