XL97: Defined Name Is Used by Form Created in Web Form Wizard

 Last reviewed: February 12, 1998
Article ID: Q161899
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SUMMARY

When you create a form with the Microsoft Excel 97 Web Form Wizard, and you select "Microsoft Internet Information Server with the Internet Database Connector" in step 3 of the wizard, Microsoft Excel inserts a defined name in the workbook form that is created by the Web Form Wizard. This defined name refers to the Uniform Resource Locator (URL) to the .idc file, which is also created by the Web Form Wizard.

NOTE: If the URL is incorrect, the form may not work correctly.

MORE INFORMATION

When you use the "Microsoft Internet Information Server with the Internet Database Connector" option with the Web Form Wizard, the following four files (the default names are listed) are created by the wizard: 

   Myform.xls
   Myform.idc
   Myform.htx
   Myform.mdb
In the "Web Form Wizard - Step 5 of 6" dialog box, you are prompted to type a URL for the .idc file. This URL does not specify where the wizard saves the file; it creates the reference for the defined name that is inserted in the Myform.xls file. For example, when the Myform.xls is created, if you specify the following URL for the .idc file in step 5 of the wizard 

   http://MyServer/Scripts/MyForm.idc
the defined name WebForm_URLOfIDC is also created in the workbook.

The reference for the defined name is the following: 

   ="http://MyServer/Scripts/MyForm.idc"
Note that this name includes quotation marks. If this is not the correct URL for the Scripts folder on the Web Server, you must rerun the Web Form Wizard and type the correct URL for the final location of the .idc file in step 5 of the wizard.

NOTE: After the Web Form Wizard creates the .htx and .idc files, you may have to move them into the Scripts folder on the Web Server. For this reason it is imperative that you specify the correct URL for the Scripts folder in step 5 of the wizard.

REFERENCES

For more information about the Web Form Wizard, click the Index tab in Microsoft Excel Help, type the following text 

   web form wizard
and then double-click the selected text to go to the "About setting up your data gathering system" topic.

Additional query words: 97 XL97 webforms
Keywords : xladdins xlweb xlwiz kberrmsg kbtool
Version : WINDOWS:97
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 12, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.