Saving a workbook without code and controls

[DenisB]

Is it possible to saveas a workbook or a worsheet, discarding the macros and the controls.
The application generates invoices, and I would like only those to be saved, without command buttons and code.

 

[DaleWatson123321]

Denis,

How about using the following method...

1) Create a template file by saving an existing invoice to a separate filename, and of course remove all the buttons and code.

2) In your application file, modify the code to:
a) Open the template file,
b) Copy the invoice data to the template file
c) Save the template file with an incremental filename - possibly including the invoice number.

Hope this helps.

Regards, Dale Watson

 

[DenisB]

Thanks Dale, an easy and elegant solution.

Best regards,
Denis.