Excel 97 - Template Wizard - Transferring Data

  • Thread starter Richard Wilding
  • Start date
R

Richard Wilding

I have a form which I have converted to an .xlt file using
the Template Wizard. When I manually save, a box pops-up
giving 2 options: 'Create New Record' and 'Continue
without updating'.
I wish to create a macro to save the document and chose
the option 'Create New Record'. I am not sure how to do
this, because when I record the macro manually there is no
difference between the two save choices. Can anyone
suggest a solution?


Thanks,
Richard
 
Top