Every one want to learn or have to learn for the sake of job little tactics in differenct applications or softwares.
This article is written to tell you that how can you get the excel filename in excel sheet which you are viewing so you come to know that on which partition of harddisk the file is stored. Here is the simple formula.
=CELL("filename")
Just write this in your excel sheet and you will get the filename and its complete path along with its sheet name in result.
I have created this blog to place some of important things on it for my personal use and also to help others. Now a days I am doing job as Software Engineer in a company. I have completed my graduation in Computer Science from University of Sindh, Jamshoro, Pakistan.
Subscribe to:
Posts (Atom)
Docker Tutorial
I have listed all the necessary commands of Docker below. In case if any is missing or if any improvement required, please share in comment...
-
Above problem occur when you have not added a group (of which User try to login) in your local policy login. To resolve the issue, follow t...
-
In my case, this error pertains to Oracle Merge query . After 30 minutes of time wastage and a lot of hunting on different forums, I come to...
-
Yesterday, I start SQL Server 2005 and try to connect with sa user but was enable to connect with the 'sa' user and got this error: ...