ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "File Name" in the spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/158700-file-name-spreadsheet.html)

Albert

"File Name" in the spreadsheet
 
I need to use the File name inside tyhe spreadsheet, but I can not find how
to link it to a cell. I found that I can use it easily in footer anf header
to print out, but I need to use it as data and manage that information. Some
body know how to link the file name and set it inside the spread sheet????

Thank you!
--
Albert

Pranav Vaidya

"File Name" in the spreadsheet
 
Hi Albert,

use CELL worksheet function as
=CELL("filename",A1)

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Albert" wrote:

I need to use the File name inside tyhe spreadsheet, but I can not find how
to link it to a cell. I found that I can use it easily in footer anf header
to print out, but I need to use it as data and manage that information. Some
body know how to link the file name and set it inside the spread sheet????

Thank you!
--
Albert


Albert

"File Name" in the spreadsheet
 
Thanks Pranav, very helpful!!!
--
Albert


"Pranav Vaidya" wrote:

Hi Albert,

use CELL worksheet function as
=CELL("filename",A1)

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Albert" wrote:

I need to use the File name inside tyhe spreadsheet, but I can not find how
to link it to a cell. I found that I can use it easily in footer anf header
to print out, but I need to use it as data and manage that information. Some
body know how to link the file name and set it inside the spread sheet????

Thank you!
--
Albert



All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com