98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Print file using macro
Print file using macro
Resolved · Medium Priority · Version 2007
Fri 18 Sep 2009, 16:31Delegate Natasha said...
Natasha has attended:
Excel VBA Intro Intermediate course
Print file using macro
how do I get a macro to print a file
Tue 22 Sep 2009, 09:36Trainer Stephen said...
RE: print file using macro
Hi Natasha
Thank you for your question
To print a worksheet you should use the printout method of the sheet object
For example
ActiveSheet.PrintOut The printout method has a number of optional arguments that can be used to specify default printers, number of pages, number of copies etc.
If you type the above line of code into the VBE, select PrintOut and press F1, you will see the detailed help for the method
Regards
Stephen
Mon 28 Sep 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Naming and Using ConstantsConstants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant. |
