How to get the excel file name path in VBA

Question

Let's say I'm writing a VBA code within the sample.xls excel file. I now want to access sample.xls' complete path in my VBA. What should I do?

Answer 1

Use FullName, for example:

strFileFullName = ThisWorkbook.FullName