Excel 2007- Saving macros in workbooks

  • Thread starter Thread starter Howard Kaikow
  • Start date Start date
H

Howard Kaikow

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?
 
Howard Kaikow said:
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?
Click to expand...

It is my understanding that the xlExcel8 constabt is the 97-2003 format.
Hopefuly, it allows macros to be saved.
 
Back
Top