Get file name to open from cell

  • Thread starter Thread starter Kashyap
  • Start date Start date
K

Kashyap

I have the below code where file name is 'Disposition'..

I need to make macro to pick file name from Sheets("Set").Range("B2").Value


Workbooks.Open ThisWorkbook.Path & "\Misc\Disposition_of_Calls.xls", True

ActiveWorkbook.Sheets("Calls_Report").Range("F2").Value =
ThisWorkbook.Sheets("mySheet").Range("L7").Value
 
Kashyap,

Workbooks.Open ThisWorkbook.Path & "\Misc\" & Sheets("Set").Range("B2").Value & ".xls", True

Or

Workbooks.Open ThisWorkbook.Path & "\Misc\" & Sheets("Set").Range("B2").Value, True

Depending on what the actual value is in Sheets("Set").Range("B2")

HTH,
Bernie
MS Excel MVP
 
Back
Top