How to make a window-like file browser to faciliate opening of files in Excel?

Posted by Pohls on June 04, 2000 11:39 PM

I want to make a file browser using Excel VBA macros. I wonder if that is possible... I'll be very grateful if anyone VBA programmers can help. Thanks.

Posted by Celia on June 04, 0100 11:59 PM

Pohls
Not sure if this what you want, but you can display the "Open File" box with the following code :-

Application.Dialogs(xlDialogOpen).Show

Celia