Path in footer

[Jook]

Does anyone know how to put the file path in the footer of spreadsheet printout. I can only get the workbook name not the complete path.

Thanks for any help.

 

[Dragracer]

Put this code into the Workbook Module.

<pre>
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet.PageSetup
.RightFooter = ActiveWorkbook.FullName
End With
End Sub

</pre>