| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create defined name using variable file name in reference
please help in create defined name
EXAMPLe: create name : ACCPath ---- Referes to (='E:\Data Folder\[externa work book.xlsx]sheet1'!$K$8:$K$10000) this works I NEED to put (external work book.xlsx) in a cell and refere to it as variable in the referes to (='E:\Data Folder\[&U2&]sheet1'!$K$8:$K$10000) where U2 having the file name because it is changing meny times |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable file reference | Excel Worksheet Functions | |||
| Create an external reference link with embedded variable | Excel Worksheet Functions | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Making a file and worksheet reference into a variable.... | Excel Worksheet Functions | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
Threaded Mode
