Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

script Expand / Collapse
Posted Friday, November 8, 2013 5:36 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 21, 2016 2:19 AM
Points: 330, Visits: 1,195
I have this code which prints files inside the tempprint folder.

TargetFolder = "C:\tempprint"
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.Namespace(TargetFolder)
Set colItems = objFolder.Items
For Each objItem In colItems
objItem.InvokeVerbEx ("Print")

But its poping up the print dialog to print every file.How do I suppress the print dialog and print all the files(300 files) in the tempprint directory smoothly.
Post #1512870
Posted Saturday, November 9, 2013 2:17 AM



Group: General Forum Members
Last Login: Today @ 5:27 AM
Points: 7,895, Visits: 5,941
Have you tried the Output-Printer command? I believe that this prints to the default printer using the default settings unless specified otherwise.


-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1512890
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse