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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create defined name using variable file name in reference
Activeworkbook.Names.Add Name:="ACCPath", RefersTo:= "=" &
Activesheet.Range("U2").Value2 --- HTH Bob Phillips "hala" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create defined name using variable file name in reference
Hi there.
You may want to try: Refers to: =''" & CELL("filename") & "sheet'1!$K$8:$K$10000 This name will be a valid name only after the workbook has been saved. Regards, Otávio "hala" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create defined name using variable file name in reference
Just in time (I did not read your post that carefully ...)
You can use the following formula to get the name from another cell: Refers to: ="'E:\Data Folder\[" & U2 & "]sheet1'!$K$8:$K$10000) Regards, Otávio "Otávio Alves Ribeiro" wrote: Hi there. You may want to try: Refers to: =''" & CELL("filename") & "sheet'1!$K$8:$K$10000 This name will be a valid name only after the workbook has been saved. Regards, Otávio "hala" wrote: 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 |
Reply |
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 |