The data tracking wizard is an addin and not part of excel. If you have it
loaded, you should be able to see what properties and methods it exposes by
looking at it in the object browser. I can't tell you which command it is,
but if no one else steps forward with the information, that is a place you
can look to see if you can find one. (you might need to create a reference
from your project to the addin to look at it in the object browser).

--
Regards,
Tom Ogilvy

"Glyn Davies" wrote in message
. ..
Good day,
I have a xls database created via the tracking template wizard and want to
update the data explicitly from a macro. I open a new workbook based on
the
template the wizard makes and add data to the cells, if I use the "save"
button I get asked if I want to add a new record or update existing one.
But
if I try to do this in a macro with:
worksbooks.save
the workbook is saved but the message box asking if I want to update/add a
record does not appear. I suspect that there is a function to do this
explicitly, can someone please tell me what it is?
TIA
Glyn