How do I save a record from an excel template to a database in a .

[Guest]

How do I save a record from an Excel template to a database in a single step.
Currently, the process is to click on file save, then when the second window
appears, select create new record, and ok. I would like to save the data as
a new record in the database using a single step.

 

[Guest]

hi,
do the whole process you just described on macro record.
Tools>macro>record new macor.
Then on the template add a command button from the toolbox
and attach the macro to it.
how?
1.drag the button from the toolbox toolbar to where you
want it.
2.right click the button>click view code.
3. between sub and end sub enter
call mymacro 'the one you just recorded.