View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default Open File Dialog box looks like

One way to achieve that will be with the following single VBA command:
SavePath = Application.FileDialog(msoFileDialogFolderPicker). Show
Micky


"Steven" wrote:

I saw where a person was opening a file using excel. The regular open dialog
box that I am used to was not being used or if it was it looked very
different. When they did open it looked more like windows explorer type
window and still had their "My Places" listed on the left.

How is that done?

Thank you,

Steven