I have Office 2003 with compatibility pack installed on my machine and add-in
written for excel in C#.NET. In this add-in, On App_WorkbookOpen event, i
want to get name and fullname of the workbook. For example:

string sFileName = theworkbook.Name;
string sFullFilePath = theworkbook.FullName;

When opening 2007 workbooks, my addin gets the name of the temp
files! So workbook.name, workbook.fullname and workbook.path all
point to the .tmp file. This works correctly for any pre-2007
workbooks.

Is there a way around this?

Thanks and Regards
Sharad