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?

wrote:

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

--

Dave Peterson

On Mar 10, 11:56*pm, Dave Peterson wrote:
If you can do it manually via the page setup, how about recording a macro while
you do it?

wrote:

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

--

Dave Peterson

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.



wrote:

On Mar 10, 11:56 pm, Dave Peterson wrote:
If you can do it manually via the page setup, how about recording a macro while
you do it?

wrote:

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

--

Dave Peterson

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

--

Dave Peterson

On Mar 11, 11:26*am, Dave Peterson wrote:
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.





wrote:

On Mar 10, 11:56 pm, Dave Peterson wrote:
If you can do it manually via the page setup, how about recording a macro while
you do it?

wrote:

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

--

Dave Peterson

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

--

Dave Peterson- Hide quoted text -

- Show quoted text -

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