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!

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

Changing printer via VBA 1

Status
Not open for further replies.
DrSmyth

DrSmyth

Technical User
Joined
Jul 16, 2003
Messages
557
Location
GB
Hi, i've got an automated report in reporter, which does a couple of things and i want it to proint to a certain printer.

I've tried rep.PrintOut("\\COURTWOODSRV1\POPPETS on Ne05:") this told me that the printer name was not valid (I got the printer name by recording a macro in Excel in which i selected the printer..

Ive also tried
ActivePrinter = "\\COURTWOODSRV1\POPPETS on Ne05:"
rep.PrintOut

But this just prints to my default printer....

Does anybody know how i can do this operation??
 
Status
Not open for further replies.

Similar threads

robinshalabh12
  • Locked
  • Question Question
VBA for BOXI
Replies
1
Views
681
kray4660
kray4660
Vik12
  • Locked
  • Question Question
Edit conditions in data provider using VBA
Replies
0
Views
576
Vik12
Vik12
kfizz
  • Locked
  • Question Question
Change a BO Query via VBA
Replies
0
Views
173
kfizz
kfizz
kfizz
  • Locked
  • Question Question
Copy BO report to Excel via VBA
Replies
7
Views
444
kfizz
kfizz
thefear
  • Locked
  • Question Question
Bulk send reports to Broadcast Agent using VBA
Replies
2
Views
241
thefear
thefear

Part and Inventory Search

Sponsor

Back
Top