Retrieve filename question, again...

  • Thread starter Thread starter µ
  • Start date Start date
Μ

µ

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.
 
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.
 
Check your other post, too.

µ said:
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.
Click to expand...
 
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!!
 
Back
Top