How to Browse file and open select file vba code
Below vba code
--------------------------------------------------------------------------------------------------------
Sub browsefileopen()
'below browse file code
myfile = Application.GetOpenFilename(, , "Browse for File")
'browse filename update with file location in active sheet.
ThisWorkbook.Sheets("sheet1").Range("a2") = myfile
'select browse file open code
Workbooks.Open myfile
End Sub
-----------------------------------------------------------------------------------------------------------------
