Hi,
If user selects cancel (condition False) then End Sub and call macro1 and if user selects file (condition True) then call macro2
This codes are for file selection.
Thanks in advance.
Sub LoadLV() Dim wb As Workbook Dim pickfile As Variant pickfile = Application.GetOpenFilename(fileFilter:="Excel Files (*.*), *.csv", _ Title:="Choose File:::::::::", MultiSelect:=False) If pickfile = False Then Exit Sub Set wb = Workbooks.Open(pickfile, True, False) End Sub