VB6 and Excel 2007

[dpnews]

I have a VB6 app that created an excel workbook from a template.
This works fine with Excel 2003.

If you run the same app with Excel 2007 the resultant workbook can only be
opened by Excel 2007.
I have set the option in Excel 2007 to save as a 2003 workbook but no luck.

Anyone any ideas

Cheers
Dave

 

[dpnews]

Solved it:

myDoc.SaveAs RTrim(FileName), xlWorkbookNormal, , , , , , True

I assume that xlWorkbooknormal uses whatever seting is defined in excel for
the default save format.