PDA

View Full Version : Printing Macro



SimonMag
10-10-2006, 12:58 AM
I am trying to get a print macro for Word XP that will let me print a document to headed paper in tray 1 and then to plain paper in tray 2, can anyone give me any help on this?

Thanks

Simon.

mdmackillop
10-10-2006, 03:31 AM
Hi Simon,
Welcome to VBAX
Here's a simplified version of what I use. You'll need to determine the correct constant values for your printer, which you can do by recording a macro changing the paper source in Page Setup. The Userform format gives much more flexibility and options than individual macros.

I also created a KB item for changing printers which may be of interest if you need watermark etc. options.

SimonMag
10-11-2006, 12:00 AM
Thanks for that, I have opened the document but I am unable to edit the macro as it does not appear in the macro list. May be a stupid question but how do I edit the Macro?
Simon.

mdmackillop
10-11-2006, 12:32 AM
The code is contained in a Userform
Press Alt + F11 to enter the Visual Basic Editor (VBE)
In the Left pane, within the Project should be a Forms folder. Open this folder.
There should be a form PrintSelector. Select this and click View/Code.
Remember to save your changes on completion.