Fullname to the cell automatic

[kko]

I have a problem: I have to have the filename of the workbook with path to a cell. There is a function called info to have path but how can you do the filename?

 

[Al Chara]

Probably an easier way but try the following:

=INFO("directory") & GetName & ".xls"

Where GetName is a defined name that is referenced as:

=GET.WORKBOOK(16)

 

[kko]

Probably an easier way but try the following:

=INFO("directory") & GetName & ".xls"

Where GetName is a defined name that is referenced as:

=GET.WORKBOOK(16)


I have a Finnish version of Excel and functions are translated to Finnish. Any resources to get functions Finnish/english translations?


kko

 

[Corni]

What about:

=cell("filename")

 

[Yogi Anand]

On 2002-05-12 18:32, Corni wrote:
What about:

=cell("filename")

Yes Corni:
=cell("filename") will provide the full filename, including the complete path.

 

[Chris Davison]

On 2002-05-12 19:40, Yogi Anand wrote:

On 2002-05-12 18:32, Corni wrote:
What about:

=cell("filename")

Yes Corni:
=cell("filename") will provide the full filename, including the complete path.

anchoring it :

=cell("filename",a1) will include the sheetname of the sheet the formula is entered in also

(can't help much with Finnish translation though, sorry!)

 

[Yogi Anand]

Hi Chris:
I have not figured out what additional benefit is there in including the second argument ... by the way with or without the second argument viz

=cell("filename")
and
=cell("filename",a1)
both give the same result including the sheet name

I know in most cases of using the cell() function with different info types, use of the second argument 'reference' is either desirable or necessary. However in case of info type 'filename', it does not seem to make any difference.

I used to make good use of the similar function cellpointer in working with Lotus 123.

Regards!
This message was edited by Yogi Anand on 2002-05-12 21:22

 

[Chris Davison]

On 2002-05-12 21:20, Yogi Anand wrote:
Hi Chris:
I have not figured out what additional benefit is there in including the second argument ... by the way with or without the second argument viz

=cell("filename")
and
=cell("filename",a1)
both give the same result including the sheet name
nd on 2002-05-12 21:22 ]</font>

Yes, it's an awkward little function.

Pop your =cell("filename") in 3 of your sheets and take a good look at what each brings back as the sheetname, you'll see they are all the same.... sheet3 on all of them, or sheet1 on all of them, depending on which sheet holds the last-used cell.

Goto sheet 1 and enter something in any cell. the fileref will read "sheet1"... take a look at sheet 2 - it will also say "sheet 1" cos of the last active cell.

This could cause havoc if you're using this as part of a relative referencing formula

(trust me, I wasted many an hour at work before I realised this !!)

Anchoring it with A1 specifies the actual sheet the formula is placed on and does not defer to whatever the last-used cell is.

(Personally, I anchor it with AA99 as I often delete cell A1 throughout the dynamic design process)



_________________
Hope this helps,
Chris
(Excel '97, Windows ME)

marker A1 anchor
This message was edited by Chris Davison on 2002-05-13 05:35

 

[Yogi Anand]

trust me, I wasted many an hour at work before I realised this !!)

Anchoring it with A1 specifies the actual sheet the formula is placed on and does not defer to whatever the last-used cell is.

Thanks Chris

Regards!