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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007- Saving macros in workbooks
"Howard Kaikow" wrote in message
... 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? It is my understanding that the xlExcel8 constabt is the 97-2003 format. Hopefuly, it allows macros to be saved. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007- Saving macros in workbooks
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007- Saving macros in workbooks
"Ron de Bruin" wrote in message
... Hi Howard See http://www.rondebruin.nl/saveas.htm Thanx. I found that earlier via google. I'll give it a try, but I've been "awake" for 16 hours now, not a good time to start playing with such things. |
Reply |
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 |