Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Selecting a pagesetup.papersize that will work on any printer
8 views
Skip to first unread message
Jamie
Nov 17, 2009, 11:24:02 PM11/17/09
to
I am using Excel VB to do billing. I have it setup to print the bills
on 4"x6" postcards. I want this code to be usable with multiple
printers. Using the pagesetup.papersize method I am able to select the
paper size. However 4x6 doesn't appear to be a standard size. If I
select 4x6 on one printer it is using papersize=120 on the other it
uses papersize=265. I don't want to hard code this, I want it to print
on a 4x6 card using any printer. Any suggestions will be greatly
appreciated. Thanks.
on 4"x6" postcards. I want this code to be usable with multiple
printers. Using the pagesetup.papersize method I am able to select the
paper size. However 4x6 doesn't appear to be a standard size. If I
select 4x6 on one printer it is using papersize=120 on the other it
uses papersize=265. I don't want to hard code this, I want it to print
on a 4x6 card using any printer. Any suggestions will be greatly
appreciated. Thanks.
Gord Dibben
Nov 18, 2009, 12:38:01 PM11/18/09
to
I can't think of any way to make a printer change paper size to one which is
not available for that printer.
not available for that printer.
Some printers allow you to create custom sizes but only one of my three
printers has that feature.
Gord Dibben MS Excel MVP
On Tue, 17 Nov 2009 20:24:02 -0800 (PST), Jamie <jamiel...@yahoo.com>
wrote:
0 new messages