Get/Copy current Excel file's path
The Excel function 

=CELL("filename",A1)


will give you the complete path to a file that has been saved. You can copy the result of the function and use Paste Values to retain only the text. 

If the file has not yet been saved, the function returns a blank.