Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

script to print excel file

Status
Not open for further replies.

kerbaule

IS-IT--Management
Dec 29, 2003
24
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
 

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top