never did that, but first shot in the dark would be to "create" via copying a template which has the macro already defined ;-)

>customer comes to run a macro in a previously created excel file. I use automation to create toe excel.
>
>I'm not shure if the macro is inside the excel (so if created from empty template) so I need to gather it from elsewhere.
>It might be in the template as well. This is not clear yet.
>
>Could this be done and if yes how?
>
>Thanks
>
>Lutz