How to Browse file and open select file vba code ~ My Excel VBA Code Example

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

-----------------------------------------------------------------------------------------------------------------

How to Browse file and open select file vba code