Clever Geek Handbook

How to create a filter for Microsoft Excel?

I want to add file type extension to Open Dialog Excel (2003 only, 2007 only, 2007 only if possible).

When the user opens my file type (i.e. myfile.myx), I want my application to read the file and enter the file into Excel in its own way (using Interop)

+1


source to share


1 answer


I think you're out of luck here. There is no documented way to extend Excel with a custom import filter (as far as I know). This converter interface exists only for Word ( http://support.microsoft.com/kb/111716 ).



If you want to change the open file dialog, you can try to subclass the dialog. This works for common Windows dialogs (see http://www.codeproject.com/KB/dialog/customize_dialog.aspx for an example), but my guess is that Office dialogs use different messages and might not allow what you want to do.

+1


source






More articles:


All Articles