Value out of range 4608 when printing Word 2002 document

S

SandyH

I wonder if someone could help me with a problem some of our users are
experiencing in Word? We have a macro that sits in Word which they can use
to print off documents. The macro selects the appropriate bins depending on
what they are printing out e.g. if its a letter, it will print the first page
on letterhead and the other pages on thick paper. The macro works
beautifully until they try and print a document that comes from outside the
office. When they hit the custom print a vba error appears saying value out
of range 4608. Everything I have read mentions section breaks and this is
what can cause the error. Some of the section breaks could be turned into
page breaks, however, other section breaks need to remain because of the way
the documents are put together. I have come across a solution which mentions
turning on the Document Grid but it appears to get this tab you need to
switch on Korean, Chinese or Japanese from the Language Settings and this
isn't something that we can do. Is there another way of bringing up this
tab? On my own pc which isn't within the citrix environment that the users
are in I activated this tab and ran the code that the author suggested of
Active.Document.PageSetup.LinesPage = 38 and after I had done that and then
ran the macro again the document printed out ok, but we can't switch on the
language settings the author suggests. Can anyone help?
 
M

macropod

Hi Sandy,

Using properly configured document templates, it shouldn't be necessary to use a macro at all. But, since you do have a macro,
perhaps it should interrogate one of Word's inbuilt document properties (eg the company name) to determine whether your print
customisations should run or the document should be printed on plain paper.
 
B

Beth Melton

SandyH said:
I wonder if someone could help me with a problem some of our users are
experiencing in Word? We have a macro that sits in Word which they can
use
to print off documents. The macro selects the appropriate bins depending
on
what they are printing out e.g. if its a letter, it will print the first
page
on letterhead and the other pages on thick paper. The macro works
beautifully until they try and print a document that comes from outside
the
office. When they hit the custom print a vba error appears saying value
out
of range 4608. Everything I have read mentions section breaks and this is
what can cause the error. Some of the section breaks could be turned into
page breaks, however, other section breaks need to remain because of the
way
the documents are put together. I have come across a solution which
mentions
turning on the Document Grid but it appears to get this tab you need to
switch on Korean, Chinese or Japanese from the Language Settings and this
isn't something that we can do. Is there another way of bringing up this
tab? On my own pc which isn't within the citrix environment that the
users
are in I activated this tab and ran the code that the author suggested of
Active.Document.PageSetup.LinesPage = 38 and after I had done that and
then
ran the macro again the document printed out ok, but we can't switch on
the
language settings the author suggests. Can anyone help?

I don't know what your macro is doing but what you describe sounds like a
strange workaround. The suggestion is to set the document to 38 lines per
page. All that does is change the document pagination. I suspect you'll
encounter the error on other documents down the road. Additionally you don't
need the options to be visible in the Word interface in order to run code
that uses a foreign language option so that indicates something else might
be wrong.

Why not post the code you are using in one of the Word VBA groups and see if
the code can be refined so you don't need to add Asian language options?

If all else fails you could always add an error handler, trap for error
number 4608, and run whatever code needs to be ran from there.
--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx
 
S

SandyH

Hi macropod

Thanks for your reply.

We have document templates that the users should use, but sometimes all they
do is copy and paste the text from one document to another instead of using
the properly formatted templates. When they print a draft of the document
all they have to do is to hit the printer icon, but when they require the
document on engrossment paper, they use the macro as this picks up the paper
from the correct engrossment paper bin on the printer without the need of
having to change the Word settings.

Regards
SandyH

macropod said:
Hi Sandy,

Using properly configured document templates, it shouldn't be necessary to use a macro at all. But, since you do have a macro,
perhaps it should interrogate one of Word's inbuilt document properties (eg the company name) to determine whether your print
customisations should run or the document should be printed on plain paper.

--
Cheers
macropod
[MVP - Microsoft Word]


SandyH said:
I wonder if someone could help me with a problem some of our users are
experiencing in Word? We have a macro that sits in Word which they can use
to print off documents. The macro selects the appropriate bins depending on
what they are printing out e.g. if its a letter, it will print the first page
on letterhead and the other pages on thick paper. The macro works
beautifully until they try and print a document that comes from outside the
office. When they hit the custom print a vba error appears saying value out
of range 4608. Everything I have read mentions section breaks and this is
what can cause the error. Some of the section breaks could be turned into
page breaks, however, other section breaks need to remain because of the way
the documents are put together. I have come across a solution which mentions
turning on the Document Grid but it appears to get this tab you need to
switch on Korean, Chinese or Japanese from the Language Settings and this
isn't something that we can do. Is there another way of bringing up this
tab? On my own pc which isn't within the citrix environment that the users
are in I activated this tab and ran the code that the author suggested of
Active.Document.PageSetup.LinesPage = 38 and after I had done that and then
ran the macro again the document printed out ok, but we can't switch on the
language settings the author suggests. Can anyone help?
 
S

SandyH

Hi Beth,

Thanks for your help. I'll have another look at it and see what can be done.

Thanks,
SandyH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top