![]() |
"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 |
"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 |
"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