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".
