Print excel file from DOS command line

  • Thread starter Thread starter despistado
  • Start date Start date
D

despistado

How can I print an Excel file from DOS command line? I am working wit
Excel 2000
 
You could create a small .vbs (scripting file) and run that.

The script opens excel, opens your file, prints the workbook, closes your file
and closes excel.

Copy this into notepad and save that file as: something.vbs

Dim XL
Dim XLWkbk

Set XL = CreateObject("excel.application")
XL.Visible = True

Set XLWkbk = XL.Workbooks.Open("C:\my documents\excel\book11.xls")

XLWkbk.PrintOut

XLWkbk.Close False
XL.Quit

Set XLWkbk = Nothing
Set XL = Nothing


===
Adjust the name/location of the file to print.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Access denied when running Excel from DOS prompt with runas comman 4
command line options/switches to print excel file 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0
DOS..BAT file problem from VB 1
Printing line numbers 3
Opening excel 2010 spreadsheet from Access 4
What is the command-line print switch in Excel? 5

Back
Top