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

Article ID: 161899

Article Last Modified on 10/22/2000

Microsoft Excel 97 Standard Edition

This article was previously published under Q161899

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: kberrmsg kbweb KB161899