Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / November 2006

Tip: Looking for answers? Try searching our database.

Select paper tray using VBScripting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
stan - 17 Nov 2006 00:37 GMT
Is it possible to tell the output from my vbscript which paper tray to
print on?  I need to print to the  lower tray (tray 3) of our HP 8150
and really would like to accomplish this through my script.  Is this
possible through any type of vb object?

Thanks,
Stan
Doug Robbins - Word MVP - 17 Nov 2006 04:24 GMT
See the following articles by fellow MVP Jonathon West

Controlling the Printer from Word VBA
Part 1: Using VBA to Select the Paper Tray
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101

Controlling the Printer from Word VBA
Part 2: Using VBA to control Duplex, Color Mode and Print Quality
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=116

Controlling the Printer from Word VBA
Part 3: Dealing with Different Paper Sizes
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=132

Controlling the Printer from Word VBA
Part 4: Getting printer driver details
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=183

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Is it possible to tell the output from my vbscript which paper tray to
> print on?  I need to print to the  lower tray (tray 3) of our HP 8150
[quoted text clipped - 3 lines]
> Thanks,
> Stan
stan - 17 Nov 2006 16:47 GMT
I'm not using Word VBA.  I've written a stand alone VBScript that I'm
wanting to accomplish this with.

Thanks,
 Stan

On Nov 16, 11:24 pm, "Doug Robbins - Word MVP"
<d...@REMOVECAPSmvps.org> wrote:
> See the following articles by fellow MVP Jonathon West
>
[quoted text clipped - 25 lines]
> > Thanks,
> > Stan- Hide quoted text -- Show quoted text -
Jonathan West - 17 Nov 2006 17:49 GMT
> I'm not using Word VBA.  I've written a stand alone VBScript that I'm
> wanting to accomplish this with.

I very much doubt that VBScript has enough of a feature set to be able to
achieve this.

But let me ask - what are you trying to print? Are you controlling Word from
the VBScript in order to do the printing?

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

stan - 18 Nov 2006 06:11 GMT
I'm controlling Business Objects through my VBScript and am able to get
the report to print but I need to tell the report which tray to print
out on.

Thanks,
 Stan

> > I'm not using Word VBA.  I've written a stand alone VBScript that I'm
> > wanting to accomplish this with.I very much doubt that VBScript has enough of a feature set to be able to
[quoted text clipped - 7 lines]
> Jonathan West - Word MVPwww.intelligentdocuments.co.uk
> Please reply to the newsgroup
Jonathan West - 18 Nov 2006 11:25 GMT
> I'm controlling Business Objects through my VBScript and am able to get
> the report to print but I need to tell the report which tray to print
> out on.

Is the report a Word document?

Do you know what printer it will be printed on?

Do you know the Tray ID for the tray you want to use on that printer?

If the answer to all these questions is "Yes", then you can proceed as
follows

1. Make sure that the ActivePrinter property is set to the correct printer

2. Set the FirstPageTray and OtherPagesTray properties of the document to
the tray

3. Print the document using the Printout method.

All these things can be done by VBScript controlling the Word object model.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

stan - 18 Nov 2006 14:57 GMT
What if the report is not a Word document?  I'm running Business
Objects not Word.

> > I'm controlling Business Objects through my VBScript and am able to get
> > the report to print but I need to tell the report which tray to print
[quoted text clipped - 20 lines]
> Jonathan West - Word MVPwww.intelligentdocuments.co.uk
> Please reply to the newsgroup
Doug Robbins - Word MVP - 18 Nov 2006 16:29 GMT
You may be better off taking a look at

http://technicalsupport.businessobjects.com/KanisaSupportSite/supportcentral/sup
portcentral.do;jsessionid=4C19B3643E3785FD812B2367AA62AE4E?id=m1


This newsgroup is for seeking help in the use of Visual Basic with Word.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> What if the report is not a Word document?  I'm running Business
> Objects not Word.
[quoted text clipped - 25 lines]
>> Jonathan West - Word MVPwww.intelligentdocuments.co.uk
>> Please reply to the newsgroup
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.