batch file for collated printing

L

Lee

Hello;

I was looking to see if there is a way to achieve the following scenario in
a batch file

in Excel 2007, the Collate check
box is cleared by default.
If you want this option checked by default in the new Excel files, we can
create a template and put it into the XLSTART folder to work around it.
Following is the key steps.
Note: As this setting is saved with the workbook, the following steps
doesn't affect the existing workbooks.
1. Open a new blank workbook in Excel 2007.
2. Click the Office button > Print.
3. In the print dialog box, click Properties > in the Advanced tab, go to
Paper/Output. Click Copy Count, set it as 2, and check the Collate. If you
want the copy count as 1, then
set it back to 1. Click OK. Now, the collate is checked. Click Close.
4. Click the Office button > Save As. Choose file type as *.xltx. Save it to
the folder: C:\Program Files\Microsoft Office\Office12\XLSTART. Name the file
as book.xltx.
5. Click Save to save it.
 

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

Top