| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text file import
Hi,
I have an external data query and am trying to create a formula that returns the name of the file from which the query data is taken. This is of course straightforward using VBA but is there a non VBA mathod of retrieving the name? Excel 2007 creates a named range with the same name as the original file name for the external data query but I cannot find anyway of accessing this inofrmation in a formula... Many thanks for any suggestions. Best wishes, Boris. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Text File - missing | Excel Discussion (Misc queries) | |||
| Set Defaults in File Import of a Text File | Excel Worksheet Functions | |||
| import from text file | Excel Discussion (Misc queries) | |||
| Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
| How To Import Text File With No Delimiters? | Excel Discussion (Misc queries) | |||
Linear Mode
