N
Neal Zimm
Hi All,
I have some general questions at the end of this background info:
I'm building an app in an addin that prints route "books" where each book
is a worksheet. A manger control's his/her Excel workbook where there will
be 10-15 route worksheets.
A printed page is NOT 8.5x11 inches, but smaller. Paper size is the same
for all mangers.
A manager can set the rows per page for each route, RowsPPg is the
variable.
I currently use horizontal page breaks for the pages, (there is only 1
vertical break per Ws) but I found that the processing is very slow when
pages, (the RowsPPg quantity of rows) are inserted / deleted and I have to
reset the horizontal break when more than a few pages are in play.
I have lots of working code re: page inserts and deletions, the row
height which controls the rows that can print on 1 page, font size, etc.
It occurred to me that if I fool with the upper and lower margins in the
Excel page setup for each route Ws, the page breaks will be "set" by Excel
and I woult not have to control the horizontal break.
Q1. Generally, sounds like the right way to go ?
Q2. I know that some trial and error will be involved, but, how close to
the bottom of a piece of paper will I be able to print ?
2a. Is there a way to override the "fix margin" messages that I get
sometimes ?
2b. Do I now have to worry about the kinds of printers the mangers
will use to print the books ? The company has many kinds of printers.
Thanks much,
Neal Z.
I have some general questions at the end of this background info:
I'm building an app in an addin that prints route "books" where each book
is a worksheet. A manger control's his/her Excel workbook where there will
be 10-15 route worksheets.
A printed page is NOT 8.5x11 inches, but smaller. Paper size is the same
for all mangers.
A manager can set the rows per page for each route, RowsPPg is the
variable.
I currently use horizontal page breaks for the pages, (there is only 1
vertical break per Ws) but I found that the processing is very slow when
pages, (the RowsPPg quantity of rows) are inserted / deleted and I have to
reset the horizontal break when more than a few pages are in play.
I have lots of working code re: page inserts and deletions, the row
height which controls the rows that can print on 1 page, font size, etc.
It occurred to me that if I fool with the upper and lower margins in the
Excel page setup for each route Ws, the page breaks will be "set" by Excel
and I woult not have to control the horizontal break.
Q1. Generally, sounds like the right way to go ?
Q2. I know that some trial and error will be involved, but, how close to
the bottom of a piece of paper will I be able to print ?
2a. Is there a way to override the "fix margin" messages that I get
sometimes ?
2b. Do I now have to worry about the kinds of printers the mangers
will use to print the books ? The company has many kinds of printers.
Thanks much,
Neal Z.