
EXCEL VBA GET FILE PATH FULL
Now, your QAT includes a text box that contains the full path for the current workbook. The command is copied to the right side of the screen.

Provided the workbook has been saved, this will return the desired information: One alternative is to use a formula in a cell to get the desired information. There are other ways to get the full path, however. You can, of course, remove the encoding characters in the URL and the protocol information to render a full path to the workbook. For instance, here is what I found when I copied the location of a workbook (Master Email List.xlsx) stored on my desktop:įile:///C:\Users\Administrator\Desktop\Master%20Email%20List.xlsx What you'll find is that the location is formatted as a URL. When you paste the information from the Clipboard, you may be in for a little bit of a surprise.

If you are using a worksheet that is brand new (it hasn't been saved yet), then the above steps won't work because there is no file name or location to note. Where Excel 2016 stores location information. Left-click on this location and Excel displays a couple of choices. Immediately under the file name is the location for the file.At the left side of the screen, click Info.Plus, they changed the precise nature of what is returned. She wonders if there is another place to get this useful information with a single copy/paste.Īctually, the information is there, but Microsoft (as it is wont to do) changed how you access the information. In Excel 2016 the information isn't there any more. This was very useful for copying the information to send to a co-worker. In previous versions of the program she could display the File tab of the ribbon and then click Info to see the complete path and filename of the workbook.
