Microsoft KB Archive/30671

Printing Multiple Copies of a Worksheet PSS ID Number: Q30671 Article last modified on 01-12-1989 PSS database name: D_MPlan

3.00 3.01 3.02 3.04

MS-DOS

Summary:

Multiplan does not contain a command that allows you to specify more than one copy of the spreadsheet to be printed. However, you can write a macro that will print multiple copies of the current worksheet.

To implement this process, you must actually write two macros that call each other. The first macro should contain the print command. It can then use the Go Macro command (’go) to call the second macro.

The second macro is the one that will control the looping process (so that it will execute a specific number of times). This second macro first must add one to a cell that it maintains as the loop counter. It should then make use of an if statement (’if) to either go back to the print macro (to print the spreadsheet again) or terminate the process once the cell containing the counter has grown to some predetermined value.

For more information on macro command codes, please see Pages 228-231 of the “Microsoft Multiplan” Versions 3.00, 3.01, 3.02, and 3.04 manuals.

Copyright Microsoft Corporation 1989.