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

I have no idea why, but WYSIWYG ain't necessarily true.

I think I would find the printer that offends worse and format it to work on
that printer.

One other option...

format|cells|alignment tab|Check Shrink to fit

(it might be passable)

sijgs wrote:

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

--

Dave Peterson

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

"Dave Peterson" wrote:

I have no idea why, but WYSIWYG ain't necessarily true.

I think I would find the printer that offends worse and format it to work on
that printer.

One other option...

format|cells|alignment tab|Check Shrink to fit

(it might be passable)

sijgs wrote:

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

--

Dave Peterson

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" wrote in message
...
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

"Dave Peterson" wrote:

I have no idea why, but WYSIWYG ain't necessarily true.

I think I would find the printer that offends worse and format it to
work on
that printer.

One other option...

format|cells|alignment tab|Check Shrink to fit

(it might be passable)

sijgs wrote:

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

--

Dave Peterson

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

"NickHK" wrote:

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" wrote in message
...
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

"Dave Peterson" wrote:

I have no idea why, but WYSIWYG ain't necessarily true.

I think I would find the printer that offends worse and format it to
work on
that printer.

One other option...

format|cells|alignment tab|Check Shrink to fit

(it might be passable)

sijgs wrote:

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

--

Dave Peterson