Hey there,

Having a small problem

How to create a new workbook from the template which exist in my current workbook when that template is selected in the ComboBox?

Basically what I need is to be able to save the template as completely new workbook in the destination folder named as invoice number from the named range =_NextInvoice and without any macro in it. Also some cells will only need to be saved as values only and some (those that contain formulas to calculate totals of the invoice) will need to be saved for further use within the new workbook. In addition, How to create link to the new workbook in my existing one so that the new workbook can be accessed via link instead of accessing it directly from within the destination folder?

My code currently letting me to go to the the cell A22 of the template selected in ComboBox, but instead I need to create all above mentioned functionality to be able to do what I really need to do.
Please Login or Register  to view this content.
Please help me here