Thread: Get file name to open from cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kashyap Kashyap is offline
external usenet poster
  
Posts: 131
Default Get file name to open from cell
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

Reply With QuoteReply With Quote