Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

script Expand / Collapse
Author
Message
Posted Friday, November 8, 2013 5:36 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:09 PM
Points: 178, Visits: 579
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")
Next

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:48 PM
Points: 5,574, Visits: 3,420
Have you tried the Output-Printer command? I believe that this prints to the default printer using the default settings unless specified otherwise.

Gaz

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

Add to briefcase

Permissions Expand / Collapse