Your xl version?
xl2007 can work with a regular .xls file
The user can open and, if desired, save as .xlsM
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken Warthen" wrote in message
...
I need to create a macro enabled Excel 2007 workbook from a routine in
another workbook. I've tried using the workbook.add method but it does
not
support the macro enabled file type or xlsm extension. Any help is always
greatly appreciated.

Ken