Jason

You need to call the macro from the add-in that does all that stuff. See
here

http://www.google.com/groups?threadm...GP11.phx .gbl

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Jason" <jht@oneboxdotcom wrote in message
...
I can't seem to find my earlier post, so here it goes again:

I set up a template that populates a list(database) using the template
wizard. I have a workflow/order of operations set up using macros and vb.

I want a button that activates the built in "template file - save to
database" functionality that you get by using the template wizard.

Here is what is happening now:
You fill in the fields and click the std toolbar save button and a message
box pops up with the heading "template file - save to database" there are
radio buttons for "add new record" and "save without updating"

When I create a button / macro and execute it, I do not get this message,
and the file simply saves. It does not update the list/database.

What I want:
is the "template file - save to database" event to trigger from my button.
I do not want the user to have to go to the std toolbar to trigger it.

Please give me a clue where to look for this command.

BTW, there is a password protected project called "3424.xls
(WZTEMPLT.XLA)"
at the top of my list of projects, that I can only assume is the Template
Wizard add-in.

Steve B. already tried helping me out, but to no avail (on this issue), I
did, however, learn a few good coding lessons. Thanks Steve!

Any other details I can give are just a post away...

thanks,
jason