Apr 28, 2005 #1 kerbaule IS-IT--Management Joined Dec 29, 2003 Messages 24 Location FR Bonjour, I need to print excel files in batch or schedule job using a script or vbscript ? Cab somebdy help me ? I don't know vbscript ... many thanks Regards Elisabeth
Bonjour, I need to print excel files in batch or schedule job using a script or vbscript ? Cab somebdy help me ? I don't know vbscript ... many thanks Regards Elisabeth
Apr 29, 2005 #2 johnnymagee Programmer Joined Apr 19, 2005 Messages 26 Location GB set oexcel = new excel.application set osht = oexcel.workbooks.open("filename") oSht.Range("toprint").PrintOut Copies:=(x), Collate:=True where x is the number of copies This will print out a range on your default printer Upvote 0 Downvote
set oexcel = new excel.application set osht = oexcel.workbooks.open("filename") oSht.Range("toprint").PrintOut Copies:=(x), Collate:=True where x is the number of copies This will print out a range on your default printer