Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Advanced Sample - Print One Invoice in Two Different Formats

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.xlsm.

Advanced Sample - Print One Invoice in Two Different Formats (IMFE Edition)

Advanced Sample - Print One Invoice in Two Different Formats - IMFE edition

Download

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you want this design to be set as the default template by the installer program.

3.40 MBDownload

Without database file. How to download and use

147 KBDownload

Download this if you have already installed IMFE, but are looking for additional customized templates.

314 KBDownload

Detail

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.

  1. First, save your invoice template in ".xlsm" format by using Excel's "File" / "Save As" command. The ".xlsm" format enables the Excel template to include VBA macro code.
  2. Switch to "Design Mode" button by pushing down the "Design Mode" button on the "Invoice" ribbon tab.
  3. Click to select the "Print" button (be sure to click the border of the button, otherwise will be activating the text box instead of selecting the entire shape object).
  4. Hit "Del" key on keyboard to delete the button.
  5. Go to Excel ribbon "Insert", pull down the "Shapes" list in the "Illustrations" group, choose the "Rectangle" shape from list.
  6. Click the location where you want to put your first new print button.
  7. Enter the button caption "Print w/ claim".
  8. Go to Excel ribbon tab "Format", and then expand the predefined shape styles from the "Shape Styles" group by clicking the "down arrow" icon, choose one of the style you like -- in this case, we choose the green background style with white foreground color.
  9. Name the button "btnInitial" by entering the name into the name box located on left corner of the formula bar.
  10. Right-click the button and choose "Assign Macro" from the shortcut menu.
  11. On the "Assign Macro" dialog box, choose "New".
  12. Excel opens the macro editor and creates an empty macro like this:
    Public Sub btnPrintWithClaim_Click()
    
    End Sub
    
  13. Fill code into the VBA procedure so that it looks like this:
    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.

  14. Repeat the above step to create the second button. This time the button caption is "Print No Claim", the button name is "btnPrintFinal", the macro code for the button looks like this:
    Public Sub btnPrintNoClaim_Click()
         Range("rgnFinal").PrintOut
    End Sub
    
  15. Save the template by clicking Excel menu "File" and then "Save".

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.

Format and Specification

Template#c5143
NameAdvanced Sample - Print One Invoice in Two Different Formats
CategoryService Invoice Template
Release DateMonday, October 22, 2018
Format (XLS or XLSX).xlsm
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)15.75
Print Area$F$3:$N$47
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top22.68
Bottom22.68