View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sijgs sijgs is offline
external usenet poster
 
Posts: 3
Default Why page too large for other printer?

I have a general report routine in Excel/VB that imports data from a .csv
file, manipulates it, and then prints it on a printer sent to Excel in a
parameter file.

Problem:

Depending on which printer it is sent to, the page is sometimes "not the
right size".

Some columns end up with #######'s and one column even ends up on another
page.

The printer is assigned before the data is imported and all columns are set
to the correct font, point size, and AUTOFIT....page setup is set to "fit one
page"

So why on some printers does it work properly (HP Officejet G Series) and
some (Lexmark Optra M412) it is too large? All printers are "installed" on
the machine that generates the report(even though the printer may physically
be on another machine), all drivers have been updated on all machines, etc.

Thanks for any ideas

JGS