The printed version.
Advanced Sample - Print One Invoice in Two Different Formats (c5143)
c5143 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open
Advanced Sample - Print One Invoice in Two Different Formats - IMFE edition
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you want this design to be set as the default template by the installer program.
Without database file. How to download and use
Download this if you have already installed IMFE, but are looking for additional customized templates.
Designed for vacuum repair shop, this template implements two print buttons - "print with claim" and "Print no claim". Both print the same invoice but the first button attaches a "claim" portion to the bottom of the invoice.
The default "Print" button included many templates here on InvoicingTemplae.com print the whole "Invoice" worksheet. This in fact prints the Excel range defined by the "Print_Area" name. There are many ways you can customize the print behavior, as shown on the samples at printable invoice templates.
In this sample, the vacuum repairer want to include the following claim on the initial invoice:
REPAIR POLICY --- PLEASE READ!
By leaving your repair, you accept and agree to this policy.
A $10.50 ESTIMATE FEE APPLIES TO ALL VACUUMS
MUST BE PICKED UP WITHIN SEVEN DAYS OF COMPLETION
AFTER 14 DAYS A $1.00 PER DAY FEE WILL ACCRUE.
REPAIRS LEFT OVER 30 DAYS WILL BE SOLD FOR CHARGES.
ESTIMATE FEES ARE POSTED AND ADHERED TO.
And on the final invoice, the claim is removed.
In this advanced sample, we implemented this by adding two new "print" buttons, as shown on the screenshots where they have green and blue background color.
The following section describes briefly the steps involved to create the buttons. This should help you understand how they works.
Public Sub btnPrintWithClaim_Click() End Sub
Public Sub btnPrintWithClaim_Click() Range("rgnInitial").PrintOut End Sub
The "On Error Resume Next" statement hides additional error messages when printing is not successful. Because Windows usually display such error message by itself - for example, if a user cancels a print job, so it is safe to hide macro error message here.
Public Sub btnPrintNoClaim_Click() Range("rgnFinal").PrintOut End Sub
The VBA macro code reference to two named range "rngInitial" and "rngFinal". When a button is clicked, the named range on the worksheet is printed out. The range "rngInitial" covers the entire central section on the "invoice" worksheet, including the "Claim" section. The range "rngFinal" does not include the "Claim" section. This allows us to print the same invoice with two different formats or form layouts.
Like other form designs here on InvoicingTemplate.com, Advanced Sample - Vary Print Results with Two Print Buttons is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.
|Name||Advanced Sample - Print One Invoice in Two Different Formats|
|Category||Service Invoice Template|
|Release Date||Monday, October 22, 2018|
|Format (XLS or XLSX)||.xlsm|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||15.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|