Help Using VBA To Create A Workbook Containing VBA

[Aldk_1]

Hi All, forum newbie looking for some advice....

In simple terms:

• I have an Excel workbook ("report creation tool") which uses VBA to create multiple new workbooks and email each outputted workbook to a recipient.
• I want to add a button into each of the outputted workbooks which runs a macro so that the recipients can complete some details then click the button to email the file back to me.

I am encountering issues attempting to attach the required macro in the outputted workbooks to the button in the outputted workbooks.

I have managed to:

• Add the code within the "report creation tool" workbook which creates the button within the outputted workbooks and imports a module into each outputted workbook containing the macro required when a recipient presses the button (button is assigned to the macro within this code).

However, when the output files are generated the button within them appears to be somehow linking back to the "report creation tool" rather than to the macro within the outputted file that it's been assigned to.

Is there an easy way to do something like this? i.e. Use VBA in one workbook to create another workbook containing a button linked to a macro within it? (recipients would not have access to the "report creation tool" workbook)

I'm no VBA expert so hoping I'm missing something fairly obvious!!

Thanks in advance for any assistance.

 

[ranman256]

problematic in vb because each user could have a different version of Office that could throw errors.
When the simple solution would be for user to click REPLY and send it back.

 

[Aldk_1]

Thanks ranman, if it helps, all users are on 365.