Why page too large for other printer?

[sijgs]

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

 

[sijgs]

adding "shrink to fit" does indeed change the font size of the offending
data, however, the overall size of the "report" is still "too big".

It seems as if there is sort of an anomoly here... you make your
spreadsheet, format it the way you want, set the printarea, then select your
printer and print.

BUT IT COMES OUT DIFFERENT DEPENDING ON WHICH PRINTER YOU CHOOSE?????

What kind of a MicroShaft is this?????

Thanx for the idea, however. ;-)

JGS

 

[NickHK]

Each printer has different capabilities and as such the "printable area" of
each will vary.
How your report is printed depends on a combination of your settings and
those of the selected printer.

NickHK

 

[sijgs]

Well, thanks to all for the ideas. Turns out, the font used on the creating
machine was not installed on the "printing" machine and so some default got
used and caused all the problems.

JGS