Excel 2007 : VBA for finding the filepath of the current open workbook

I'm trying to write code that will look at the filepath of the workbook I am currently in and enters it into a given cell (say A1) for reference in the following code:

ActiveWorkbook.SaveAs Filename:= _
"M:\!00-ME PROJECTS\Procurement Support\Supplier Audits\Triumph " & WorkbookName & ".xls "

In other words, the file path you see above, I need to generate that automatically so that no matter what file I am in the Macro can be run.... hope this makes sense!

Thanks guys!