Print excel file from DOS command line

  • Thread starter Thread starter despistado
  • Start date Start date
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.
 

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
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
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top