LinkBack URL
About LinkBacksHow to find the path of an excel workbook immediately after the same work book is opened.
regards,
D.S.Rama Rao.
Path of an opened excel workbook
How to find the path of an excel workbook immediately after the same work book is opened.
regards,
D.S.Rama Rao.
Last edited by D.S.Rama Rao; 11-25-2010 at 05:02 AM.
Hi,
Go to File>>Properties>>General you will find the Location that is the path of that file.
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Dear rahul nagar,Originally Posted by Rahul Nagar
The method you have suggeted is for a file which is not opened. i want the method to find the path of a file which is opened.
I hope the above is clear.
regards,
D.S. Rama Rao.
Check the attached file.
Dear Rahul Nagar,
I Thank you very much for replying to my quests.Perhaps i am not able to express my self correctly my exact requirement . What i want is to find out the path of the opened file in a cell through excel function to enable me to use that cell reference in my subsequent programming of excel work sheet.
That is as soon as i open the workbook the workbook shall find out in which path it is and compare it whith the path given in another cell and if both are not same notify accordingly.Else workbok should operate normally.
i hope i have made myself more clear now
regards
D S Rama Rao
msgbox activeworkbook.fullname
Entia non sunt multiplicanda sine necessitate
=CELL("filename",A1)
and for just the path
=LEFT(CELL("filename",A1),SEARCH("[",CELL("filename",A1))-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks