How to open a workbook specifying its path

by

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 & "D8 L538-L550_16MY_Powertrain Metrics_20131002.xlsm"

    Set wb = Workbooks.Open(sFile)
End Sub

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Function to convert column number to letter?
  3. Read/Parse text file line by line in VBA
  4. How do I find the last column with data?
  5. Better way to find last used row
  6. Excel VBA: Answer gets “stuck”
  7. 2 Dimensional array from range [closed]
  8. Save multiple sheets to .pdf
  9. filter out multiple criteria using excel vba
  10. Excel VBA autofilter all but three
  11. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  12. Dir() function not working in Mac Excel 2011 VBA
  13. Excel VBA code to copy a specific string to clipboard
  14. Merge values of column B based on common values on column A
  15. How to use workbook.saveas with automatic Overwrite
  16. How to import a table from web page (with “div class”) to excel?
  17. Excel VBA – Range.Copy transpose paste
  18. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  19. How do you get a Range to return its Name?
  20. Passing variable from Form to Module in VBA
  21. Excel VBA: Convert a date string to a Unix timestamp
  22. excel to pdf ignores print area and calls printer
  23. In Excel, can I use a hyperlink to run vba macro?
  24. Excel VBA – exit for loop
  25. Are ActiveX Controls Disabled?
  26. VBA WinHTTP to download file from password proteced https website
  27. Create folder path if does not exist (saving from VBA)
  28. Concatenate multiple ranges using vba
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment