Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2003
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Template Wizard not working (Excel 2000)

    Hello!

    I've built a survey to ask users their opinions on a new piece of software we're trialing. My survey is a mix of blank cells for 'open ended' answers, and drop down lists. I've used the Template Wizard to siphon answers off into a database spreadsheet. However, when I open my template, I receive a message that says 'No Return() or Halt () function found on Macro sheet. Although I *did* have a save macro in the workbook (which the users could access by clicking on a Submit button), I have deleted that macro. I have even copied all my questions & pasted them into a new sheet, re-adding all formatting & lists, but still each time I add the Template Wizard to a new workbook, I end up with that message. And no data makes it across to my database...

    Any ideas would be gratefully accepted, as I'd promised to have this survey done by tomorrow (have been working on it for a week). I've searched microsoft.com to no avail & am completely stumped. [img]/forums/images/smilies/sad.gif[/img]

    Deborah

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Template Wizard not working (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Deborah

    I think, the template you have may have some old XLM code. This is what I see from your post, 'No Return() or Halt ().

    So you will need to:

    1) Figure out the XLM code and add the 'No Return() or Halt () functions,

    2) Redesign your survey without the template.

    If you would post a sample of the application without the data, or with dummy data, the group here will be able to debug this for you, and make it work. This is clearly a problem with the macro code, at least that is what I see while sitting here... <img src=/S/eyeout.gif border=0 alt=eyeout width=15 height=15>

    If you need any further help, please post a reply to this message.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Aug 2003
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Template Wizard not working (Excel 2000)

    Thank-you very much!

    I've no idea why I would have old XLM code (or what that is, really), but if I need more help, I will certainly get back to you.

    Currently, a work colleague has had success with my template simply by making sure my fields are empty (I had default text in each field that said 'click here to add your answer'). When all the fields are empty, she doesn't get the Return() or Halt() message when she opens the template. If that holds until tomorrow, I may be in the clear!

    <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

    Thanks again,
    Deborah

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Template Wizard not working (Excel 2000)

    Hi Deborah

    XLM stands for Excel Macro, and it is the macro programming code that was prior to Excel version 5 when the macro programing language became VBA, Visual Basic for Applications.

    Some aspects of Excel still has that old functionality in it, and I am not sure when, if at all, XLM will be truly dead and removed from Excel.

    The fields being empty may have something to do with the macro code running to evaluate the fields, test it with empty fields and then enter some data both legitimate and wrong data to test it in all conditions before you can say you are out of the woods.

    Make sure you think of any situation that the user may do, you know you can never trust the users to be on their best behavior...

    Hope all will be well.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •