B
Bonnie Conrad
I used Microsoft KB 231805 to create a module which collates and
prints two reports and created a macro to call that module. I need to
make sure all pages of both reports print (both reports are the same
size) so I set the parameters at 300 pages (larger than either report
will ever be). The code run by the macro is
CollateReports(300,"rpt1", "rpt2")
Is there a way to print all pages of the report without specifying a
number? Is it possible to use a wildcard so it will print 10 pages if
the reports are 10 pages long or 100 pages if they are 100 pages long.
Right now, the macro continues to run after all pages have been
spooled to the printer, then gives a run time error when it hits 300.
Any help greatly appreciated.
Thanks,
Bonnie
prints two reports and created a macro to call that module. I need to
make sure all pages of both reports print (both reports are the same
size) so I set the parameters at 300 pages (larger than either report
will ever be). The code run by the macro is
CollateReports(300,"rpt1", "rpt2")
Is there a way to print all pages of the report without specifying a
number? Is it possible to use a wildcard so it will print 10 pages if
the reports are 10 pages long or 100 pages if they are 100 pages long.
Right now, the macro continues to run after all pages have been
spooled to the printer, then gives a run time error when it hits 300.
Any help greatly appreciated.
Thanks,
Bonnie