Coding/Script

[Excel VBA] File open / 파일열기

chobocho 2016. 12. 20. 00:24
Excel VBA : Open file with dialog box







Sub OpenFile()
    Dim chooseFileName As Variant
    chooseFileName = Application.GetOpenFilename(FileFilter:="XML Files(*.xml), *.xml", Title:="Select XML file")

    If chooseFileName <> False Then
       Debug.Print chooseFileName
    Else
       Exit Sub
    End If
End Sub

  • MSDN Link