M
mcmcalex
Hi,
I'm trying to print an entire workbook as a publication and have
created a macro that prints each individual sheet, with chapter pages
correctly inserted (I have a sheet called Chpts with all the chapters
listed, and the macro prints the contents of one row for each chapter
'page'). The print run will then print: Cover, TOC, the chapter 1
Heading [Chpts.Row1], SummaryData, Chapter 2 heading [Chpts.Row2],
ExpData, etc etc.
What I want to do is set the print job so that it prints on both sides
of the page. Therefore, if a sheet has only one page (or an odd
number of pages) then the data on the next sheet will print on the back
of the page that this sheet's data is on. At the moment, the chapter
pages are all blank on the back, and I want to put data there. Does
anybody know how to do this?
I've tried printing to file and then sending the file to print through
DOS, but it seems if you print to file, then that file will only print
(at a printer) correctly if it is a text file.
Thanks for any help
mcalex
I'm trying to print an entire workbook as a publication and have
created a macro that prints each individual sheet, with chapter pages
correctly inserted (I have a sheet called Chpts with all the chapters
listed, and the macro prints the contents of one row for each chapter
'page'). The print run will then print: Cover, TOC, the chapter 1
Heading [Chpts.Row1], SummaryData, Chapter 2 heading [Chpts.Row2],
ExpData, etc etc.
What I want to do is set the print job so that it prints on both sides
of the page. Therefore, if a sheet has only one page (or an odd
number of pages) then the data on the next sheet will print on the back
of the page that this sheet's data is on. At the moment, the chapter
pages are all blank on the back, and I want to put data there. Does
anybody know how to do this?
I've tried printing to file and then sending the file to print through
DOS, but it seems if you print to file, then that file will only print
(at a printer) correctly if it is a text file.
Thanks for any help
mcalex