| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting values from a filename as a date in a cell
Try http://xcell05.free.fr/english/
-- David Biddulph "Teddy-B" wrote in message ... The site is suspended. Is there another site to get the morefunc addin? Could you post a hyperlink? Many Thanks: Teddy B "Dave Peterson" wrote: First, you'd want to format that date value in A1: ...&text(a1,"dd-mmm-yy")&... And you'd want to use =indirect() in your formula. But the bad news is your formula will work as long as that sending workbook is open. As soon as you close that workbook (and excel recalcs), you'll get an error. If you're going to have that sending workbook closed, then Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ That includes =indirect.ext() that may help you. Me wrote: Hi I have several excel files which automatically save as a date. I would like to add a function to get data from a file defined in a cell. I have tried ="[("&A1&").xls]"&"Pay_Details'!$C$6" but it displays #REF! not sure if this is becaus of the date format or some other problem. eg. saved files "23-Sep-07", "30-Sep-07" Main spreadsheet A1= 23-Sep-07 B1- Datat from "23-Sep-07" file A2= 30-Sep-07 B2- Datat from "23-Sep-07" file Any help would be greatly appreciated -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding date for filename | Excel Discussion (Misc queries) | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| set filename to <filename-date on open | Excel Worksheet Functions | |||
| How to automate footers (filename/date) for all new spreadsheets? | Excel Worksheet Functions | |||
| Using TODAY() to generate a filename from where values are VLOOKUPed | Links and Linking in Excel | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
