mdelatorre icon

Displays the File Open box with VBA

mdelatorre | PRO | 05/24/12 05:06:56 AM UTC | 0 ⭐ | 794 šŸ‘ļø | Never ā° | []
VisualBasic |

280 B

|

None

|

0 šŸ‘

/

0 šŸ‘Ž

Sub TestIt()
NewFN = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls", Title:="Please select a file")
If NewFN = False Then
' They pressed Cancel
MsgBox "Stopping because you did not select a file"
Exit Sub
Else
Workbooks.Open Filename:=NewFN
End If
End Sub

Comments