Re: Set Word Options in VBA for Word 2007

Although users do not run this macro daily, however, it is very handy when
they get very creative and start to try to set the options that will either
cause some problems or conflict with firm's standard (like use straight quote
or smart quote, etc.). In reality, this macro is being run more often than I
wish. It is a concern because it takes 7 minutes and my own experience is
that I'll terminate the process when it takes that long. However, I've
figured out the problem due to the prompt of "conneting to printer"; somehow
Word will try to connect to printer in many of the settings, I happened to
set the default printer on my Vista PC to a shared printer on a Windows xp on
network, the connection is slooooooow. When I reset the printer to a local
one (I do not really have one, so I set it to "fax"), then the macro finishes
in a minute. Although it is still not as fast as in 2000/2003, at least it
is acceptable now. I still don't understand the needs to connect to printer
for most of these settings, such as MeasurementUnit, ...etc. It will be
great if any one can tell me how to turn that off ...

"Doug Robbins - Word MVP" wrote:

If it is only something that is done occasionally for the purpose that you
mention, why worry about the performance.

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Cora" <Cora@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
The macro does more than just the settings stored in the "Data" key.
Besides, the "Data" key might store something I do not want to "reset".
macro is meant for the end users to "reset" the Word settings to certain
standard of the firm whenever they feel need it. Although it will not be
hard to write a macro to restore the "Data" key to certain value, I have
found the documentation of what information stored in "Data" key and in
way, it is binary. I do know that it gets corrupted some time. Do you
where I can find the documentation? And maybe I can modify the registry
instead of Word Object to speed up the process.

Thanks again.

"Graham Mayor" wrote:

Why should this macro be necessary? Word 2003 had a few issues with the
registry entries being randomly changed (probably as a result of the data
key being adversely affected by errant add-ins), but I don't recall
any reports of this occurring with other Word versions. Wouldn't you be
better simply backing up the Word data key from the registry, and forget
your macro?

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site
Word MVP web site
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Cora wrote:
I've created a macro to set Word Options to my needs in Word 2007. It
includes most of the properties settings for Options object and some
properties settings for Application & Window/View object. It runs
VERY SLOW. I stepped through each line of codes and found half of the
settings take several seconds to finish. The similar macro I created
for Word 97/2000/2002/2003 run very smoothly, took just a second to
finish all. I've noticed the message "conneting to printer .." shown
on the status bar when the macro run and tried to turn off
"Application.ScreenUpdating", no difference. Does any one know how
to fix this problem?

Thanks in advance.


Relevant Pages

  • Re: Set Word Options in VBA for Word 2007
    ... I agree - in any case, user settings are none of your business. ... Word MVP web site ... it will not be hard to write a macro to restore the "Data" key to ...
  • RE: Display revision bars only
    ... "Lene Fredborg" wrote: ... Track Changes Option settings it ... I still get revision bars and no inline markup. ... If you want to make a macro that sets your "normal" track changes settings, ...
  • Re: Printing default for Word
    ... True but you could use a macro. ... Sub DraftPrint() ... Word MVP web site ... > settings within the document. ...
  • RE: Display revision bars only
    ... The macro as such only affects the settings. ... I still get revision bars and no inline markup. ... select Tools> Options> Track Changes tab and select the settings you want. ...
  • Re: what happened to the scroll bars in Word?
    ... them correcting this error so it's a poorly behaved add-in to start with -- ... I have all default security settings, except I have Vista UAC disabled. ... are being changed then I'd say the macro is in template you are using. ... Recorder to "record" themselves modifying a setting in their Options ...