How to Get a Full File Path in Excel?

Ever needed to find out the full path of your current file? What I mean by full path here is the full location of the active file including the directory path and full file name.

If you did, then what you need is this following code:

Application.ActiveWorkbook.FullName

The one line code will return the full directory path + filename of the active file, ex:
D:\My Directory\filename.xls

To simply use it from our formula bar, we can wrap the code into excel vba function like this:

Function FULLFILENAME()

     FULLFILENAME = Application.ActiveWorkbook.FullName

End Function

Every time we needed the information, just call the FULLFILENAME function from the formula bar.

This entry was posted in Excel Formula, Excel VBA Function, Workbook and Worksheet and tagged , , . Bookmark the permalink.

34 Responses to How to Get a Full File Path in Excel?

  1. Pingback: debt consolidation companies

  2. Pingback: reverse mortgage calculators

  3. Pingback: credit counseling

  4. Pingback: debt consolidation companies

  5. Pingback: consolidate loan

  6. Pingback: reverse mortgages pros and cons

  7. Pingback: beat maker software

  8. Pingback: video x

  9. Pingback: acid reflux symptoms

  10. Pingback: debt collection agency

  11. Pingback: Calgary Wedding Photography

  12. Pingback: collection agency rates

  13. Pingback: What is inflation

  14. Pingback: general exclaim uhp

  15. Pingback: debt collection agency

  16. Pingback: rencontre Laval

  17. Pingback: collection agency newsletter

  18. Pingback: free credit report and score

  19. Pingback: leo trader pro review

  20. Pingback: rewardzone mastercard

  21. Pingback: Furry

  22. Pingback: wedding photographer calgary

  23. Pingback: free movies online

  24. Pingback: Spyderco Knife Deals

  25. Pingback: barcode app

  26. Pingback: Wedding Photographers

  27. Pingback: Best Gaming Headset

  28. Pingback: Montreal Escorts

  29. Pingback: underwater digital camera

  30. Pingback: Blackhatlinks.com

  31. Pingback: Kutjes

  32. Pingback: Best Gaming Headset

  33. Pingback: ?????????? ???

  34. Pingback: coupon king

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>