ThisWorkbook.Path returns the path of the workbook containing that code.ActiveWorkbook.Path returns the path of the active workbook.If the workbook has not yet been saved, no path is returned.