Adding custom file formats to Excel?

Hi,

In a custom application of Excel 2003, I wish to use a special file
format. It's based on XML, but too complicated for Excel's native XML
support. The idea is to open files of this kind in Excel, make use of
Excel's nice editing capabilities, and then save back into the same format.

The ideal would be to add this file format to the others in the Open and
Save As dialogs, but I'm not sure if this is possible. Next best would
be to add two special menu items for import and export on the File menu,
or on a custom menu.

In short, my question is: can I add my file format to the others in the
Open and Save As dialogs?

Gus

AFAIK, no.

In article <[email protected]>,
Gustaf Liljegren <[email protected]> wrote:

> In short, my question is: can I add my file format to the others in the
> Open and Save As dialogs?
>
> Gus

"Gustaf Liljegren" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> In a custom application of Excel 2003, I wish to use a special file
> format. It's based on XML, but too complicated for Excel's native XML
> support. The idea is to open files of this kind in Excel, make use of
> Excel's nice editing capabilities, and then save back into the same
format.
>
> The ideal would be to add this file format to the others in the Open and
> Save As dialogs, but I'm not sure if this is possible. Next best would
> be to add two special menu items for import and export on the File menu,
> or on a custom menu.
>
> In short, my question is: can I add my file format to the others in the
> Open and Save As dialogs?
>
> Gus

Let's see if I understand this. Ypu want to create a file with a different
fileformat like myfile.glg and then you want Excel to call your own code
whenver a user opens such a file? Short answer is No. The only way, as I see
it, is that you create a com addin and add your own special file menu which
can only open glg files You will have yo pen the file in your code, parse it
and then populate the sheet with values.

/Fredrik