Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HP Quick Sets?

Status
Not open for further replies.

colinmitton

Technical User
Feb 24, 2005
190
GB
Is there a way of using VBA (in word 2003) to call a HP quick set?

I have set up some quick sets to do things like duplex printing for different types of paper and as my search to find out if VBA can tell a printer to print in duplex (not manual duplex) has failed, so I thought I would try a different approach!

If someone does know how to use VBA to print using the printers duplex unit that would be fantastic and a most welcomed help.

Thanks folks.
 
I did ask this question before on the forum! sorry for duplicating but I'm still interested if anyone has found a way yet!

Thanks
 




Hi,

I've asked Hewlet Packard. Nada!

I've asked Oce (plotter). Nada!

It seems as if it would be possible, but I have run into brick walls.

Skip,

[glasses] [red][/red]
[tongue]
 
It's worth exploring the new printer object. I send reports to our HP4600 using custom settings like this:
Code:
Dim prt As Printer

DoCmd.OpenReport strReportCode, acViewDesign
Set prt = Reports(strReportCode).Printer
prt.Duplex = acPRDPSimplex
prt.Orientation = acPRORLandscape
prt.PaperBin = 2  'acPRBNMiddle
DoCmd.PrintOut
DoCmd.Close ObjectType:=acReport, ObjectName:=strReportCode, Save:=acSaveYes
Set prt = Nothing

If this approach may work, it will be helpful to enumerate the actual values for you printers' trays.
A demo for this (odc_acc10_printers.exe) can be downloaded for free at MSKB or MSDN. Sorry I don't have a link for you.
Hope this helps!

10 is company, 11 is a crowd
 
Thanks for the replys.
I've already tried the second of the links that LMB supplied and it was for manual duplexing. This did work fine and needed no tweaking! but for a printer with a duplex unit it does cause some issues. I will use it though for little desk top prints that dont have the duplex units.

Thanks for the code & info that genomon posted. I'm forwarding to a friend who a programmer as its a little out of me league!

If I find a way be sure I'll let everyone know.

Thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top