If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Use insert to move cell data. | achyam | Tables | 0 | October 22nd, 2004 01:21 AM |
Can I insert a cell into the subject line of an email hyperlink? | orangeturtle36 | General Discussion | 1 | September 10th, 2004 05:30 PM |
Excel macro to insert rows if a cell does not equal the value above that cell | JSD | General Discussion | 3 | August 12th, 2004 07:29 PM |
IF only.....IF only.... | SmokingMirror | Worksheet Functions | 8 | August 7th, 2004 07:37 PM |