Foncesa
09-09-2022, 10:44 AM
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
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