Can I pgrogramatically access Track Changes?

's Computer Specifications

When a workbook is shared one has the option to view the changes that various
users have made. Is there any way to programatically access those changes>

Thanks,

Russ

's Computer Specifications

I have never tried it, but as I recall, the changes are stored in a hidden
sheet named HISTORY. You might see if such a sheet exist and see what it
looks like. That could be accessed programmatically.

--
Regards,
Tom Ogilvy

"xrbbaker" wrote:

> When a workbook is shared one has the option to view the changes that various
> users have made. Is there any way to programatically access those changes>
>
> Thanks,
>
> Russ

's Computer Specifications

Thanks Tom. I'll check it out.

"Tom Ogilvy" wrote:

> I have never tried it, but as I recall, the changes are stored in a hidden
> sheet named HISTORY. You might see if such a sheet exist and see what it
> looks like. That could be accessed programmatically.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "xrbbaker" wrote:
>
> > When a workbook is shared one has the option to view the changes that various
> > users have made. Is there any way to programatically access those changes>
> >
> > Thanks,
> >
> > Russ

's Computer Specifications

Russ,

This code will generate the History sheet that Tom mentioned. When you save
the workbook, it seems Excel automatically deletes the History sheet. But I
guess you can just always re-generate the History Sheet whenever you need it.

Sub ShowHistory
ActiveWorkbook.ListChangesOnNewSheet = True
End Sub

--
Hope that helps.

Vergel Adriano

"xrbbaker" wrote:

> When a workbook is shared one has the option to view the changes that various
> users have made. Is there any way to programatically access those changes>
>
> Thanks,
>
> Russ

's Computer Specifications

That's handy. thanks Vergel.

"Vergel Adriano" wrote:

> Russ,
>
> This code will generate the History sheet that Tom mentioned. When you save
> the workbook, it seems Excel automatically deletes the History sheet. But I
> guess you can just always re-generate the History Sheet whenever you need it.
>
>
> Sub ShowHistory
> ActiveWorkbook.ListChangesOnNewSheet = True
> End Sub
>
>
> --
> Hope that helps.
>
> Vergel Adriano
>
>
> "xrbbaker" wrote:
>
> > When a workbook is shared one has the option to view the changes that various
> > users have made. Is there any way to programatically access those changes>
> >
> > Thanks,
> >
> > Russ

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Track User Access	anonymous	Microsoft Outlook	0	27th Oct 2006 08:03 PM
Can Access track user changes?	=?Utf-8?B?VGVkZCBO?=	Microsoft Access	2	27th Oct 2005 01:33 AM
Access - Track Changes	Don M	Microsoft Access Database Table Design	5	6th May 2004 11:34 PM
Access and Outlook - automatically generate emails if I track addresses in Access	BP	Microsoft Access Getting Started	5	27th Mar 2004 12:05 PM
track file access	Jon Delano	Microsoft Windows 2000 File System	2	20th Jan 2004 09:16 PM