Saving in XLSM

C

Charly

Hello everyone!

Is it possible, in Excel 2007, forcing the registration of certain
specific workbooks in xls format with macros (XLSM)?

If yes, how do I proceed?

Thank you for your valuable assistance

Charles
 
J

Jim Rech

I don't know what you mean by 'forcing the registration'. If you want to
convert XLS workbooks to XLSM you're going to have to open them in Excel
2007 and do a Save As to the new format. Or use a macro that does that.
 
C

Charly

Hello Jim,

Thank you for your help.

In fact, I have an application composed of several templates workbooks
(XLTM). When the user selects a template, and save this workbook, by
default, Excel propose the format XLS without macro. Most of users don't pay
attention to this and, thereafter, can no longer use the buttons and other
tools programmed in their workbook
Kind regards
Charles
 
J

Jim Rech

by default, Excel propose the format XLS without macro.

XLSX I think you meant. Yes this is most unfortunate; I wish MS had done
more work on this. I do not have a real solution for this problem however.
Maybe you can add a Before_Save macro that warns the user but I haven't
tried this out.


--
Jim
| Hello Jim,
|
| Thank you for your help.
|
| In fact, I have an application composed of several templates workbooks
| (XLTM). When the user selects a template, and save this workbook, by
| default, Excel propose the format XLS without macro. Most of users don't
pay
| attention to this and, thereafter, can no longer use the buttons and other
| tools programmed in their workbook
| Kind regards
| Charles
|
| "Jim Rech" <[email protected]> a écrit dans le message de | (e-mail address removed)...
| >I don't know what you mean by 'forcing the registration'. If you want to
| >convert XLS workbooks to XLSM you're going to have to open them in Excel
| >2007 and do a Save As to the new format. Or use a macro that does that.
| >
| >
| > --
| > Jim
| > | >> Hello everyone!
| >>
| >> Is it possible, in Excel 2007, forcing the registration of certain
| >> specific workbooks in xls format with macros (XLSM)?
| >>
| >> If yes, how do I proceed?
| >>
| >> Thank you for your valuable assistance
| >>
| >> Charles
| >>
| >
| >
|
|
 
R

Ron de Bruin

For the OP

I report this problem to MS a few months ago

A xltm template workbook must default to xlsm with saving and not look at the default file format.
You can change the default save format to xlsm to avoid this problem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top