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