Export from excel into an invoice template

[Guest]

Can I export selected data from an excel worksheet into an excel invoice
template?

 

[NickHK]

Set SourceWB=ThisWorkbook
Set DestinationWB=Workbook.Open("Invoice.xls")

With SourceWB
DestinationWB.Range("InvoiceNo").Value=.Range("InvoiceNo").Value
...etc

That what you mean ?

NickHK

With This