open dialog box 1

[venkman]

Is there a way to display the open file dialog box in Excel? I know you can use GetOpenFilename(), but that doesn't actually open the files, it just returns the array. I'd like to have a fully functional Open dialog that works exactly the same as if you clicked "file->open...".

Thanks,
Venkman

 

[SkipVought]

Hi,

How 'bout...

    Application.Dialogs(xlDialogOpen).Show

Check for Built-In Dialog Box Argument Lists in Excel help.




Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[venkman]

Gotcha, exactly what I was looking for.
Thanks,
Venkman