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

Adding custom file formats to Excel?
 

AFAIK, no.

In article ,
Gustaf Liljegren wrote:

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

Gus

Adding custom file formats to Excel?
 

"Gustaf Liljegren" wrote in message
...
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