Printing Reports: Macros or VBA ?

[JesseL]

I have 15 reports that i am printing. I used a macro to print all of these at once. What is faster, VBA or the Macro? I would like the best solution. Thanks

ksharp

 

[scking]

Actually, the question should not be the speed but which may be better. Macros have absolutely not capability to handle errors during the process and will always give critical errors if you attempt to cancel or experience any other type errors. VBA allows you to handle these problems. All developers should consider error handling as an important piece of the development process.
----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------

 

[Homma]

I'm no expert, but have developed some databases for the company I work for.I created a form to "print all reports" at the click of a button (which a macro was required listing all the reports I wanted to print). I have a total of 29 Reports which I print daily that range from 1 page to 72 pages.This method suites me as I can do other things until my job has finished printing.

Happy Programming ! !

Homma