excel - How to open a workbook specifying its path

Question

Sub openwb()  
    ChDir "E:sarathPTMetrics20131004D8 L538-L550 16MY"
    Workbooks("D8 L538-L550_16MY_Powertrain Metrics_20131002.xlsm").Open    
End sub

Here, I am getting an error saying Subscript out of range on 3rd line. What should I do to open a workbook specifying its path?

Answer 1

Workbooks.open("E:sarathPTMetrics20131004D8 L538-L550 16MYD8 L538-L550_16MY_Powertrain Metrics_20131002.xlsm")

Or, in a more structured way...

Sub openwb()
    Dim sPath As String, sFile As String
    Dim wb As Workbook

    sPath = "E:sarathPTMetrics20131004D8 L538-L550 16MY"
    sFile = sPath & "D8 L538-L550_16MY_Powertrain Metrics_20131002.xlsm"

    Set wb = Workbooks.Open(sFile)
End Sub