How to open a workbook specifying its path

Question

Sub openwb         ChDir  E  sarath PTMetrics 20131004 D8 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

User · Accepted Answer

Workbooks open  E  sarath PTMetrics 20131004 D8 L538-L550 16MY D8 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  sarath PTMetrics 20131004 D8 L538-L550 16MY       sFile   sPath  amp   D8 L538-L550 16MY Powertrain Metrics 20131002 xlsm       Set wb   Workbooks Open sFile  End Sub

User · Answer

You can also open a required file through a prompt  This helps when you want to select file from different path and different file     Sub openwb   Dim wkbk As Workbook Dim NewFile As Variant  NewFile   Application GetOpenFilename  microsoft excel files    xlsm      xlsm     If NewFile  lt  gt  False Then Set wkbk   Workbooks Open NewFile  End If End Sub

[excel] How to open a workbook specifying its path

Examples related to excel

Examples related to vba