You can use Workbooks.Open to open excel file in excel vba.
Nội dung chính
Example
Following example open excel file with read-only option.
Public Function openExcelFile(ByVal openFileName As String, _
Optional ByVal readOnly As Boolean) As Workbook
readOnly = (readOnly And True)
Application.DisplayAlerts = False
Workbooks.Open Filename:=openFileName, readOnly:=readOnly
Set openExcelFile = ActiveWorkbook
End Function
