*resolved*get the full filename (with path and all) of the active workbook in Excel?

[odedyer]

How can I get the full filename (with path and all) of the active workbook in Excel? Is there a function that returns it?
For example, ActiveWorkbook.Name would give me "Book1.xls", but I want a function that would return "C:\Documents and Settings\MyUsername\My Documents\Book1.xls".

[NeedSomeAnswers]

This should do it !

Dim strNameAndPath As String


strNameAndPath = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name