Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert value of a cell as a filename
Is there a way to insert the value of a cell as a filename for referencing a
cell in another workbook? ex: =<FileName!$Col&Row where <FileName is a variable text string indicating the name of the workbook desired to be referenced. The application involved is such that a user would open up an Excel file that serves as a data conversion tool. To set up, the user enters their account information by entering in thier ID number. The ID number is the variable portion of the text string that a file name is named by. ex: ="ReportName"+UserID+".csv" where FileName is the Name given the cell containing the concatenated text string and UserID is the variable portion of the file name by way of an ID number of the target user to receive the report. I have tried different syntax to have the variable be read as literal text such as: 'FileName 'FileName' '(FileName) '(FileName)' '=(FileName) '=(FileName)' '(=FileName) '(=FileName)' I will receive either a message of "That name is not valid" or an Update Values prompt for "(FileName)" when FileName is a Name in the workbook whose cell reference already has a value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenging Charting | Charts and Charting in Excel | |||
How do I insert an image into a specific cell within a protected . | Excel Discussion (Misc queries) | |||
How to insert a complex formula in a cell with VBA | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
parse cell and insert rows? | Excel Worksheet Functions |