Hi Howard

See
http://www.rondebruin.nl/saveas.htm

--

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




"Howard Kaikow" wrote in message ...
It is my understanding that macros cannot be included in a .xlsx file.

I am programmatically creating a workbook and creating code.

In Excel 2003, no problem, I just use the xlWorkbookNormal file format.
But I'm still confused about Excel 2007.

1. If the user chooses to do so, could I save macros in an Excel 2003
compatible format? If so, what is the appropriate FileFormat constant?

2. I will also give the user the choice of using either xlsm or xlsb
formats. Any issues of which I need to be aware?