Check Dictionary, Paper Size, etc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Writer - 05 Nov 2006 22:53 GMT

Does anyone know how to build in some VBA code that will check that the
office template has the following attributes assigned at startup:

1. Paper size = A4
2. Standard Set of Styles is being used
3. Language = Australian

and so forth.

Reply to this Message

Jezebel - 05 Nov 2006 23:20 GMT

> Does anyone know how to build in some VBA code that will check that the
> office template has the following attributes assigned at startup:
>
> 1. Paper size = A4

activedocument.PageSetup.PaperSize = wdPaperA4

> 2. Standard Set of Styles is being used

Depends what you mean by the 'standard set of styles'. This usually means
whatever styles are defined in the template.

> 3. Language = Australian

activedocument.Styles("normal").LanguageID = wdEnglishAUS

If you really want to be thorough, you need to check this for every style.

However, these questions suggest a misconception about how to use templates
in an organisation: part of their function is precisely to standardise these
matters. So checking the template is self-defeating: if a user has made
unauthorized changes to the office template, then won't they also have
zapped the code you're proposing to run?

Reply to this Message

Writer - 07 Nov 2006 23:28 GMT

> > Does anyone know how to build in some VBA code that will check that the
> > office template has the following attributes assigned at startup:
[quoted text clipped - 19 lines]
> unauthorized changes to the office template, then won't they also have
> zapped the code you're proposing to run?

Reply to this Message

Writer - 09 Nov 2006 00:31 GMT

Hi Jezebel,

I agree with you... do you have any ideas where security is concerned?

Writer

> > > Does anyone know how to build in some VBA code that will check that the
> > > office template has the following attributes assigned at startup:
[quoted text clipped - 19 lines]
> > unauthorized changes to the office template, then won't they also have
> > zapped the code you're proposing to run?

Reply to this Message

Jezebel - 09 Nov 2006 04:33 GMT

> Hi Jezebel,
>
> I agree with you... do you have any ideas where security is concerned?
>
> Writer

If you're worried about people making unauthorized changes to documents and
templates, the general answer is: politely ask them not to. Most users will
respect that (or don't know enough to screw around anyway); and there's
truly nothing you can do to stop a determined, maliciously inclined user. If
they want to fake a version of your letterhead with their own address on it,
they can always create it from scratch.

Reply to this Message