FileDialog in VBA

Get FileName using Fileopen Dialog box

Function RetrieveFileName() Dim sFileName As String sFileName = Application.GetOpenFilename If sFileName = "False" Then sFileName = "" RetrieveFileName = sFileName End Function