Excel OLE – .NET COM AddIn behaves differently when Excel is embedded in an application

I havent used OfficeXP, but have built COM AddIns against 2000, 2003 and 2007.

I recently built a COM AddIn for Office 2007 using the IRibbonExtensibility interface, with references to the v12 PIAs.

When I used this with Office 2003, I found it worked pretty well. However, my AddIns is only providing some very basic functionality and not using many calls onto the Excel objects. I adjusted the OnConnection method to set up the CommandBars only if the Applicaiton.Version was less than 12.

There were no code changes that I remember needed to switch from 2003 PIAs to 2007 PIAs. In the past have found you can switch between different versions of the PIAs with minimum effort.

James

Alex is correct, but as you have to export to csv, you can give the users this advice when opening the csv files:

1. Save the exported file as a csv
2. Open Excel
3. Import the data using Data-->Import External Data --> Import Data
4. Select the file type of "csv" and browse to your file
5. In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier)
6. Change the Delimiter to comma
7. Select where to import to and Finish

This way the special characters should show correctly.