Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

VBscript or SSIS - send document to specific printer

Problem:  I need to send an excel report directly to a specific printer when the report completes.

Using either SSIS or VBscript, what is the best way to do this?

a) the report runs in SSIS in SQL Server 2008
b) the report is exported to Excel

Thank you.
0
Brugge2
Asked:
Brugge2
1 Solution
 
RobSampsonCommented:
Hi, it sounds like the report has a macro to "complete" it, so add this on the end:

strOriginalPrinter = Application.ActivePrinter
strNewPrinter = "the new printer name"
Application.ActivePrinter = "strNewPrinter"
ActiveSheet.PrintOut
Application.ActivePrinter = strOriginalPrinter

Regards,

Rob.
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now