1.

Solve : Print from DOS Batch File?

Answer»

I am running a SQL DTS Extract to an Excel spreadsheet. I would like to print this spreadsheet from a DOS batch file so I can schedule it using Task Manager, but don't know the syntax.

We are a Terminal Services, so our printers are all defined on a DOMAIN Controller. I've LOOKED at the PRINT command but can't seem to GET it to work.

Any ideas from the experts?

Thanks,
LeslieTry printing the XLS from within Excel. If you pass along the spreadsheet name on the Excel command line, it will OPEN the workbook and then use an Auto_Open macro (that you write) to do the printing of the entire workbook or selected sheets.

Excel workbooks contain many special characters and probably confuse the PRINT command.

Hope this helps.



Discussion

No Comment Found