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.

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.

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

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.