| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007- Saving macros in workbooks
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Add-in in Excel 2007 (Global Macros) | Excel Programming | |||
| Excel 2007: Macros not working in password-protected workbooks | Excel Programming | |||
| Excel 2003 Workbooks with macros (.xls) converted to Excel 2007 | Excel Discussion (Misc queries) | |||
| Closing excel and saving workbooks | Excel Programming | |||
| saving excel workbooks | Excel Programming | |||
Threaded Mode
