Track changes
 

Hello All

I am using Windows 2K Professional & Office97.
I have a macro in an access mdb that outputs various files in excel format.

Is it possible either:

to use access VBA instead of the access macro to specify that the excel
'Track Changes' option is automatically set to 'True'; or
to specify elsewhere that all new excel files to have the 'Track Changes'
option automatically set to 'True'

In either case, the sub-options 'When' should be set to All, 'Who' set to
Everyone, and 'Where' should be left blank (i.e. applies to the whole
sheet)?

I'm sure this can be done, but just can't see how!
I would be grateful for any help.

Many thanks
Les