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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 12:57 PM
Points: 295, Visits: 1,095
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: Saturday, May 14, 2016 10:56 AM
Points: 7,381, Visits: 5,359
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