Paper Sizes

One of the most annoying things for users is discovering that their printer does not recognize the paper sizes used in your templates. If you use templates for your reports, you should always change the paper size to the user's default size. This can easily be determined by creating a new workbook and reading off the paper size from the PageSetup object.

Excel 2002 added the Application.MapPaperSize property to automatically switch between the equivalent common paper sizes of different countries (for example, between Letter in the U.S. and A4 in the UK). If this is property is set to True, Excel should take care of paper sizes for you.

0 0

Post a comment