Save a New Invoice with a Macro already Included

[Code Ghost]

Good morning community!
This is my first question in this forum. Thanks in advance for your time and help.

I created an invoice using VBA that is saved in a specific folder in an XLSM format.
Can this new invoice be saved with a new included VBA code that would copy information to a different workbook?

I need the saved invoice to have an added macro.
The purpose of this macro is to copy partial payments to the new invoice to a different workbook under a Payment column: Amount1/Amount2, to: Amount6

There, I think I should be able to add a SUM formula to calculate the balance in a different column.

My big problem would be to save a new invoice with a macro already included.

I included two images below.

Thank you for your help!

 

[Joe4]

Welcome to the Board!

Create a template that already has the format and macro you desire, then use your code to open a copy of that, populate it, and save it as your new invoice.

 

[Code Ghost]

Welcome to the Board!

Create a template that already has the format and macro you desire, then use your code to open a copy of that, populate it, and save it as your new invoice.

Hi Joe4!
Thank you so much for your reply. I deeply appreciate your time.
In the meantime, I went another way and will post a different question.
Thanks a million again for your help.