print 4 pages on 1 page using vba

  • Thread starter Thread starter ickook
  • Start date Start date
I

ickook

Hi
I am trying to print 4 pages on 1 page. I know you can do this through
the page setup,and it works well.
But I am after a way to do it with vba code, not having any success.
Any help would be much appericated.
Regards
mick
 
If you can do it manually via the page setup, how about recording a macro while
you do it?
 
If you can do it manually via the page setup, how about recording a macrowhile
you do it?
Click to expand...

Thanks for the reply Dave. I have tried recording the macro via page
setup, but when I look at the code there is no reference to changing
the number of pages.
Regards
Mick
 
I wasn't sure what you meant by printing 4 pages on one page. But it sounds
like your printer has a nice feature that can print 4-up (4 logical pages on one
physical page).

If that's true, then it sounds like you won't be able to control that setting
from VBA. But that's a guess. My printer doesn't have this feature.

How about an alternative?

Install a second copy of the printer driver and change its default settings
(through the control panel|printer applet) to do what you want.

Then you could change printers, print, and then change printers back.
 
I wasn't sure what you meant by printing 4 pages on one page.  But it sounds
like your printer has a nice feature that can print 4-up (4 logical pageson one
physical page).

If that's true, then it sounds like you won't be able to control that setting
from VBA.  But that's a guess.  My printer doesn't have this feature.

How about an alternative?

Install a second copy of the printer driver and change its default settings
(through the control panel|printer applet) to do what you want.

Then you could change printers, print, and then change printers back.








--

Dave Peterson- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks Dave
I will try the what you suggest, it sounds like an another way do
doing it.
regards
Mick
 
Back
Top