Getting a file name using a built in dialog box

  • Thread starter Thread starter Steven Revell
  • Start date Start date
S

Steven Revell

Hi,

I was wondering how to get the filename (as opposed to
opening the file) from an excel built in dialog box. I can
do it in word but the same commands don't apply in excel
vba.

Thanks Steven
 
fname = Application.GetOpenFileName( see help for arguments)

Shows the file open dialog, and returns the selected file(s) names as a
string ( or array, multiselect:=true) without opening the file.

Also Application.GetSaveAsFilename
 
Back
Top