Good Morning Everyone,
Ok, I have a problem with an application I wrote using Excel Automation. I am using Visual Studio 2008 and VB.Net. My development machine has both Excel 2003 and Excel 2007 installed. In my project references, I am referencing Microsoft.Office.Excel.Interop version 11.000 (2003). In the properties for the DLL reference, I have Copy Local set to true and Use Specific Version set to true. However, in the output window as the program runs, it clearly loads version 12.00(2007). Now, the spreadsheet is created without any errors. However, when I try to open the file using either version of Excel, I get the following message:
"The file you are trying to open "filename.xls" is in a different format than the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
In Excel 2007, you can open the file no problem. With Excel 2003, the file is unusable. The vast majority of our users still use earlier versions of excel so I really need to make this thing use the v11 dll's. What am I missing?
Thanks,
Don
Ok, I have a problem with an application I wrote using Excel Automation. I am using Visual Studio 2008 and VB.Net. My development machine has both Excel 2003 and Excel 2007 installed. In my project references, I am referencing Microsoft.Office.Excel.Interop version 11.000 (2003). In the properties for the DLL reference, I have Copy Local set to true and Use Specific Version set to true. However, in the output window as the program runs, it clearly loads version 12.00(2007). Now, the spreadsheet is created without any errors. However, when I try to open the file using either version of Excel, I get the following message:
"The file you are trying to open "filename.xls" is in a different format than the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
In Excel 2007, you can open the file no problem. With Excel 2003, the file is unusable. The vast majority of our users still use earlier versions of excel so I really need to make this thing use the v11 dll's. What am I missing?
Thanks,
Don