ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you automatically insert a file path in an Excel document? (https://www.excelbanter.com/excel-discussion-misc-queries/78624-can-you-automatically-insert-file-path-excel-document.html)

Mimi

Can you automatically insert a file path in an Excel document?
 


Gilles Desjardins

Can you automatically insert a file path in an Excel document?
 
Hi Mimi,

Type the following function in a cell:

=INFO("directory")


HTH

Gilles
"Mimi" wrote in message
...




Gilles Desjardins

Can you automatically insert a file path in an Excel document?
 
OR you can try this:

=CELL("filename")

Gilles

"Mimi" wrote in message
...





All times are GMT +1. The time now is 02:16 PM.

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