Click to See Complete Forum and Search --> : Printing using word macros


gazzak
May 6th, 2003, 11:00 AM
Hi All,
Anybody out there know about printing from word using a macro? If so, read on....

We have a customer who is printing to 8 Hewlett Packard printers, (all identical and spread throughout the building), using a word macro so that it's basically idiot proof! Click and print. They print brochures that use cover sheets and the macro basically selects the cover sheet from the correct tray, and another insert from yet another tray, and the users can select the printer closest to them. This works fine, and they are happy with it. OK so far?
They ordered a new printer which has just been installed. It's not a HP, it's totally different. They want the macro to print to this new printer without making any modifications to their macro, and from testing it so far it just wont work correctly. The customer is adamant that the macro should be able to print to the new printer and is not prepared to change it in any way. I'm of the opinion that the macro HAS to be changed, surely the new printer will have different tray codes???

Any opinions on this issue? Willl the current macro work with a different printer? Open to offers, thanks in advance.

DonJ
May 6th, 2003, 11:09 AM
Yes, you're right...the new printer will "probably" have different tray codes, etc. You didn't mention what type the new printer is...

Also, you might just need to go in and edit your macro:

"Open a macro in the Visual Basic Editor to make corrections, remove unnecessary steps, rename or copy individual macros, or add instructions that you cannot record in Microsoft Word.

On the Tools menu, point to Macro, and then click Macros.
In the Macro name box, click the name of the macro you want to edit.
If the macro doesn't appear in the list, select a different document or template in the Macros in box.

Click Edit. "


I know you said your customer doesn't want to do this but it just might be necesarry...or, at least, create another one for this new printer.

Also, make sure that the correct printer is selected from the drop down menu in File/Print.

Just a couple of suggestions...let us know how it all ends up.