Export from excel into an invoice template

G

Guest

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Data from another source to use in an excel template 0
VBA Button to save worksheet 1
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Access "OutputTo" Command HTML Template 0
Auto increment a cell 14
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Macro Active Page Name 7
Export from Office 2003 Excel to Access 4

Top