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.

Go to the Office Button Excel Options Save. Select the Macro-Enabled
Workbook format on the default drop-down.
--
I am running on Office 2003, unless otherwise stated.


"PatrickS" 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.

Thanks Orion Cochrane,

Although I didn't post the question, I was wondering the same thing.

--
A. Ch. Eirinberg


"Orion Cochrane" wrote:

Go to the Office Button Excel Options Save. Select the Macro-Enabled
Workbook format on the default drop-down.
--
I am running on Office 2003, unless otherwise stated.


"PatrickS" 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.

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.

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.

Cool!

I finally installed 2007 on the weekend but will be a while until up to
speed with these sorts of things.


Gord

On Tue, 27 Jan 2009 23:32:32 +0100, "Ron de Bruin"
wrote:

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

I finally installed 2007 on the weekend

Great Gord, good to hear.

Have fun



--

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


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Cool!

I finally installed 2007 on the weekend but will be a while until up to
speed with these sorts of things.


Gord

On Tue, 27 Jan 2009 23:32:32 +0100, "Ron de Bruin"
wrote:

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