| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get file name to open from cell
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 "Kashyap" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get file name to open from cell
Thanks Bernie
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Open excel file when file name is entered in cell | Excel Programming | |||
| using cell value to open file | Excel Programming | |||
| open file by inputting file name in cell? | Excel Discussion (Misc queries) | |||
| Open file with file name from cell | Excel Programming | |||
| Open file from Cell | Excel Programming | |||
Linear Mode
