LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 42
Default How do I prevent a bmp from printing over two pages

OK, this gets kind of complicated.

I wrote a macro. The (printing) result can be anywhere from 1 to 4 pages.
I really have no way of knowing, in advance, how many pages it will be
because there are so many variables.

Anyway ... when the macro is finished running, the very last step is that
the macro perfoms an "Insert Picture From File" after the last line of data.
(The picture is a bitmap but I can make it a jpg or whatever ... I created it
from Visio.) The problem is that, sometimes, the bitmap prints ("bleeds")
over two pages ... in other words, part of the bitmap prints at the end
(bottom) of page two, for example, and continues at the top of page three (or
it starts at the bottom of page one and continues at the top of page two).

I need to make sure that the entire bitmap prints altogether on the same
page. So, how do I say, in a macro: "if there's not enough room to print the
entire bitmap at the bottom of page one (or two or three) , then position it
(insert it/move it down) so that it prints, entirely, at the top of the next
page?

Thanks. Dan
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 printing problem--printing 1 document on 2 pages Bons Excel Discussion (Misc queries) 0 December 24th 09 04:15 PM
How to I prevent a row from breaking across pages? ... rllngriver Excel Discussion (Misc queries) 2 February 27th 08 05:45 PM
How to prevent extra blank pages from printing? Cathy Excel Discussion (Misc queries) 4 July 4th 07 12:38 PM
How do I delete pages in Excel? Keeps printing blank pages at end. Jojobean Charts and Charting in Excel 1 May 31st 07 07:37 AM
How to I prevent a row from breaking across pages? tbaam Excel Discussion (Misc queries) 1 March 20th 06 07:35 PM


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"