Vba Excel do vlookup from a closed file

by

You will need the full path.

Example

Option Explicit
Public Sub Example()
    Dim Path As String

    Path = "C:\Temp\"

    With ThisWorkbook.Sheets("Sheet1")
        .Range("B1").Formula = "=VLOOKUP(A1,'" & Path & "[Book1.xlsx]Sheet2'!A:J,3,FALSE)"
    End With
End Sub

VLOOKUP function

More Related Contents:

  1. VBA – How to grab the cell below if a cell has text?
  2. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  3. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  4. Excel Macro, inserting internationally valid formula during run-time
  5. Excel VBA Formula German/French/Italian/Russian/Dutch/Foreign Function
  6. TextJoin UDF For Excel 2013
  7. VBA macro that search for file in multiple subfolders
  8. So, I have 6 “master” files to then divide into 40 separate files
  9. Getting ScriptControl to work with Excel 2010 x64
  10. Application.Match gives type mismatch
  11. Count and Highlight keywords within phrases
  12. Transpose a range in VBA
  13. Detect merged cells in VBA Excel with MergeArea
  14. Find last used cell in Excel VBA
  15. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  16. Parse HTML content in VBA
  17. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  18. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  19. Should I turn .CutCopyMode back on before exiting my sub procedure?
  20. Determine whether user is adding or deleting rows
  21. How to use VBA SaveAs without closing calling workbook?
  22. VBA.Find and adding a value
  23. excel vba- extract text between 2 characters
  24. Round function in Excel, worksheet function vs VBA
  25. How to continue the code on the next line in VBA
  26. Excel VBA Userform – Execute Sub when something changes
  27. Count the number of rows in another sheet [duplicate]
  28. VBA Password Input with Cancel Function
  29. Finding first blank row, then writing to it
  30. VBA inheritance, analog of super

Leave a Comment