I would suggest Excel has no idea what a new unsaved workbook contains.

There is a way to test it in 2007 Gord
This is new in 2007 HasVBProject

See how I use it here
http://www.rondebruin.nl/saveas.htm

Case 52:
If .HasVBProject Then
FileExtStr = ".xlsm": FileFormatNum = 52
Else
FileExtStr = ".xlsx": FileFormatNum = 51
End If


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Why can't excel choose .xlsm instead when macros are present so
that stuff isn't lost when you save?

I would suggest Excel has no idea what a new unsaved workbook contains.


Gord Dibben MS Excel MVP

On Tue, 27 Jan 2009 09:40:01 -0800, PatrickS
<msdn_newsgroups001@_removetextplusunderscores_seu rre.com. wrote:

Is there any way to force excel 2007 to save in .xlsm format by default? At
the moment it seems to always try and save in .xlsx format by default
regardless of whether there are macros in the workbook or not. This seems a
little odd. Why can't excel choose .xlsm instead when macros are present so
that stuff isn't lost when you save?

In any case is there any way of changing the default file format in excel
2007? I'm assuming that the user would normally have to do something, but we
regularly send out spreadsheets with macros in it, and Excel 2007 users
equally have problems when they inevitably save it in .xlsx format.