Yes, you need a saved file on your system to run a macro. A macro cannot be created dynamically from ActiveX, but must be created in Excel and saved as a workbook, template or an add-in. Your best three choices are:
1. Save your macro in a workbook and use it like a template. Instead of creating a new workbook, load the template, put in your data, run the macro and then use Save As to rename the file. This adds the macro to every data file.
2. Save the macro in a Macros.xls file and open this workbook before you run the macro. Add "Macros.xls!" to the name of the macro.
3. Save the Macros.xls file in the XLStart folder. This workbook will be loaded every time you start Excel.
Michael
www.abcdefirm.com
