S
senman
I have created an excel template (form) that is linked to
an excel database. I would like to add a couple of macros
to the form (Save record to database and continue) and one
(Save record and exit). When I try to create the macro
with the RECORD MACRO, it does not record the dialog box
that pops which asked you if you want to create a new
recorded in the database. There is no need to save each
individual record just the database. I am trying to make
it an easy step for those entering the data so all they
have to do is hit the macro and not worry about not saving
the template (which we do not want saved multiple times as
an excel file). Please advise how I might get this
information or who I might be able to call.
thank you for your assistance. I have tried everything I
can think of. I'm not real familiar with Macros
Susan Enman
BIODESIGN International
207-283-6500 ext 131
(e-mail address removed)
an excel database. I would like to add a couple of macros
to the form (Save record to database and continue) and one
(Save record and exit). When I try to create the macro
with the RECORD MACRO, it does not record the dialog box
that pops which asked you if you want to create a new
recorded in the database. There is no need to save each
individual record just the database. I am trying to make
it an easy step for those entering the data so all they
have to do is hit the macro and not worry about not saving
the template (which we do not want saved multiple times as
an excel file). Please advise how I might get this
information or who I might be able to call.
thank you for your assistance. I have tried everything I
can think of. I'm not real familiar with Macros
Susan Enman
BIODESIGN International
207-283-6500 ext 131
(e-mail address removed)