I have a workbook that uses macros to print the appropriate sheets based on
user entries. Fairly simple macros, and that part is working. Thing is, on
one pc, the pages print fine(using a Xerox Document Centre 230), going to
the tray with yellow paper, as well as all the margins being correct, etc...
On another pc, initially it wasn't going to the proper tray, but I think
that's fixed now(wasn't set up in the printer properties), but the margins
are all wrong! What fits on one page on one pc, takes two pages to print on
another pc! From everything I can tell, the two pc's are using the exact
same driver! To me it sounds like a driver problem, but I don't know any
way to verify that they are indeed the exact same build, etc...

Help!??

43fan wrote:
I have a workbook that uses macros to print the appropriate sheets
based on user entries. Fairly simple macros, and that part is
working. Thing is, on one pc, the pages print fine(using a Xerox
Document Centre 230), going to the tray with yellow paper, as well as
all the margins being correct, etc... On another pc, initially it
wasn't going to the proper tray, but I think that's fixed now(wasn't
set up in the printer properties), but the margins are all wrong!
What fits on one page on one pc, takes two pages to print on another
pc! From everything I can tell, the two pc's are using the exact same
driver! To me it sounds like a driver problem, but I don't know any
way to verify that they are indeed the exact same build, etc...

Help!??

It still after all these years crops up that Excel has problems printing
a 600dpi document at 300dpi; it can't seem to make the "one page is one
page" idea stick. That might be the problem here. The page is sent at
600dpi, and the printer is defaulted to 300dpi, making the page twice
the size that is expected.

Q

"Quaoar" wrote in message
...
43fan wrote:
I have a workbook that uses macros to print the appropriate sheets
based on user entries. Fairly simple macros, and that part is
working. Thing is, on one pc, the pages print fine(using a Xerox
Document Centre 230), going to the tray with yellow paper, as well as
all the margins being correct, etc... On another pc, initially it
wasn't going to the proper tray, but I think that's fixed now(wasn't
set up in the printer properties), but the margins are all wrong!
What fits on one page on one pc, takes two pages to print on another
pc! From everything I can tell, the two pc's are using the exact same
driver! To me it sounds like a driver problem, but I don't know any
way to verify that they are indeed the exact same build, etc...

Help!??

It still after all these years crops up that Excel has problems printing
a 600dpi document at 300dpi; it can't seem to make the "one page is one
page" idea stick. That might be the problem here. The page is sent at
600dpi, and the printer is defaulted to 300dpi, making the page twice
the size that is expected.

Q

Q,

Not the problem. Printer is set to 600dpi, and that's the only setting
available under page setup in Excel. :( It's just totally weird to me...