ExcelBanter - Data Tracking - Update only with "save"

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Data Tracking - Update only with "save" (https://www.excelbanter.com/excel-programming/289939-data-tracking-update-only-save.html)

Data Tracking - Update only with "save"

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

Data Tracking - Update only with "save"

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

Data Tracking - Update only with "save"

You don't need to be able to see the code to look in the object browser. It
shows what properties and methods are exposed.

--
Regards,
Tom Ogilvy

"Glyn Davies" wrote in message
...
Thanks Tom, but the code is password protected! Anyone know the
password.....
Tom Ogilvy wrote:

220 0 article
From: "Tom Ogilvy"
Newsgroups: microsoft.public.excel.programming
Subject: Data Tracking - Update only with "save"
Date: Mon, 2 Feb 2004 09:41:19 -0500
Organization: Posted via Supernews, http://www.supernews.com
Message-ID:
References:
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Complaints-To:
Lines: 29
Path:

TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!newsfeed.icl.net
!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!sma ll.news.tele.dk!sn-xit-02!
sn-xit-04!sn-xit-01!sn-post-01!supernews.com!news.supernews.com!not-for-mail
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.excel.programming:463565

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).