Result example, in case of a drive - E:\Data\Personal Files\Photos\Holiday (Here, A1 refers to the cell where the formula is being placed) Step1 (FORMULA-A): Formula to identify the path of the excel file To summarize the explanation, we simply place a formula to retrieve the path of the file and then extract only the drive name/IP address from the path. I have given the break-down explanation of the formula below. This formula will auto-detect and return the the drive name OR the IP address (in case if it's a server) in which the workbook is located. You may use the following formula assuming that ' A1' is the cell where you intend to paste this formula: However, I have come up with a direct solution to your problem. I'm not sure if you would still find this helpful.
0 Comments
Leave a Reply. |