Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Retrieve filename question, again...
In an other topic I asked about how to retrieve the filename from an
Excelfile. Many solutions followed. I tested many of them at home but, when i got to work they didn't work anymore... When i use the function =cell("filename") and i type this into the function wizard, it gives "volatile" as result. When i continue and enter this in a cell, it shows.. nothing... Does this have anything to do with the fact that the title of the spreadsheet is generated by a database program? We get these excel files from within a Lotus Notes environment. Let's say i have this spreadsheet named: Calculations.xls and i open it from within Lotus Notes, the title is changed into: document opened as read only - calculations.xls (revision 5.0) It seems i cannot approach this generated title with =cell("filename") Any thoughts? Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Retrieve filename question, again...
Hi mu:
first it should be: =CELL("filename",A1) and this will return a blank unless the file has first been save. Save the file and then enter the formula. -- Gary's Student gsnu200706 "µ" wrote: In an other topic I asked about how to retrieve the filename from an Excelfile. Many solutions followed. I tested many of them at home but, when i got to work they didn't work anymore... When i use the function =cell("filename") and i type this into the function wizard, it gives "volatile" as result. When i continue and enter this in a cell, it shows.. nothing... Does this have anything to do with the fact that the title of the spreadsheet is generated by a database program? We get these excel files from within a Lotus Notes environment. Let's say i have this spreadsheet named: Calculations.xls and i open it from within Lotus Notes, the title is changed into: document opened as read only - calculations.xls (revision 5.0) It seems i cannot approach this generated title with =cell("filename") Any thoughts? Thanks. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Retrieve filename question, again...
Check your other post, too.
"µ" wrote: In an other topic I asked about how to retrieve the filename from an Excelfile. Many solutions followed. I tested many of them at home but, when i got to work they didn't work anymore... When i use the function =cell("filename") and i type this into the function wizard, it gives "volatile" as result. When i continue and enter this in a cell, it shows.. nothing... Does this have anything to do with the fact that the title of the spreadsheet is generated by a database program? We get these excel files from within a Lotus Notes environment. Let's say i have this spreadsheet named: Calculations.xls and i open it from within Lotus Notes, the title is changed into: document opened as read only - calculations.xls (revision 5.0) It seems i cannot approach this generated title with =cell("filename") Any thoughts? Thanks. -- Dave Peterson |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Retrieve filename question, again...
Thanks!!!
But i guess i already tried that :-( The file i've tried it on exists already, and during testing i tried to include a reference. Tomorrow i'm going to try it again, can't figure out why such a simple thing wouldn't work. My guess is that there must be something wrong with the filename being generated by a database program... Thanks again!! On Thu, 15 Feb 2007 10:53:13 -0800, Gary''s Student wrote: Hi mu: first it should be: =CELL("filename",A1) and this will return a blank unless the file has first been save. Save the file and then enter the formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
+ in filename | Excel Discussion (Misc queries) | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Cell value/filename question... | Excel Discussion (Misc queries) | |||
Retrieve data | Excel Discussion (Misc queries) | |||
2 Question: Coloumn width, Filename | Excel Worksheet Functions |