add in, specifically "filename" function

  • Thread starter Thread starter Carla
  • Start date Start date
C

Carla

I use this at home, works fine. Tried it at work, no
luck. Checked the appropriate add in box and installed
from CD, but still won't work. Unchecked and rechecked
box, rebooted and a few other things, but won't work.

Can anyone help?

Thanks,
Carla
 
Hi Carla
you may provide some more information: what add-in are you using, what
does not work, etc :-)
 
I am trying to use specifically the "filename" function.
It shows you the path of the entire filename including the
sheet name.

I have achieved the end result by having the filename
printing on my worksheet, but had to use custom footer
instead. I can live with this, but want to know why the
add in function of "filename" doesn't work properly.

Carla
 
Hi Carla
this is not an add-in function. I guess you have used something like
=CELL("filename",A1)
if yes could you please post your complete formula which does not work
(copy it as-it-is from your workbook and post it here).

If you only want a part of this result (path+filename+sheetname)
displayed you may use the following formulas:
File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))
 
It is also an add in, and it was a formula something like
what you explained below =filename(). When I went to
help, it did explain that it was an add in, which is how I
always got it to work on new computers in the past. But
anyway, I used your =cell("filename") and it worked
wonderfully! By the way, what is the A1 part of your
formula for?

Thanks,
Carla
-----Original Message-----
Hi Carla
this is not an add-in function. I guess you have used something like
=CELL("filename",A1)
if yes could you please post your complete formula which does not work
(copy it as-it-is from your workbook and post it here).

If you only want a part of this result (path+filename+sheetname)
displayed you may use the following formulas:
File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)- 1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1) +1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND ("]",CELL("file
name",A1),1))


--
Regards
Frank Kabel
Frankfurt, Germany

I am trying to use specifically the "filename" function.
It shows you the path of the entire filename including the
sheet name.

I have achieved the end result by having the filename
printing on my worksheet, but had to use custom footer
instead. I can live with this, but want to know why the
add in function of "filename" doesn't work properly.

Carla
Click to expand...

.
Click to expand...
 
Hi Carla
the A1 part is for referencing the current sheet. Without it this
formula would return the sheetname form the last ACTIVE sheet in your
workbook

--
Regards
Frank Kabel
Frankfurt, Germany


It is also an add in, and it was a formula something like
what you explained below =filename(). When I went to
help, it did explain that it was an add in, which is how I
always got it to work on new computers in the past. But
anyway, I used your =cell("filename") and it worked
wonderfully! By the way, what is the A1 part of your
formula for?

Thanks,
Carla
-----Original Message-----
Hi Carla
this is not an add-in function. I guess you have used something like
=CELL("filename",A1)
if yes could you please post your complete formula which does not
work (copy it as-it-is from your workbook and post it here).

If you only want a part of this result (path+filename+sheetname)
displayed you may use the following formulas:
File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)- 1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)
+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND
("]",CELL("file name",A1),1))


--
Regards
Frank Kabel
Frankfurt, Germany

I am trying to use specifically the "filename" function.
It shows you the path of the entire filename including the
sheet name.

I have achieved the end result by having the filename
printing on my worksheet, but had to use custom footer
instead. I can live with this, but want to know why the
add in function of "filename" doesn't work properly.

Carla

-----Original Message-----
Hi Carla
you may provide some more information: what add-in are you using,
what does not work, etc :-)

--
Regards
Frank Kabel
Frankfurt, Germany


Carla wrote:
I use this at home, works fine. Tried it at work, no
luck. Checked the appropriate add in box and installed
from CD, but still won't work. Unchecked and rechecked
box, rebooted and a few other things, but won't work.

Can anyone help?

Thanks,
Carla

.
Click to expand...

.
Click to expand...
Click to expand...
 
Minor quibble - CELL("filename") with no reference argument returns the
sheet name from the last sheet in which a cell was changed, not merely
the last active sheet.
 
Minor quibble - CELL("filename") with no reference argument returns the
sheet name from the last sheet in which a cell was changed, not merely
the last active sheet.
Click to expand...
...

Quibble: CELL(FirstArgOnly) always implicitly refers to the active cell when
Excel last recalced. This is identical to how Lotus 123's @CELLPOINTER works,
which is what Microsoft intended with CELL() fed only one argument. Enter
CELL("Filename") in a cell, move anywhere else, enter nothing but press [F9],
return to the cell containing this formula and see what it evaluates to.
 
Thanks Harlan - I'd forgotten the basis (and so referred to XL's Help -
which should have been my first clue...).
 
Back
Top