Microsoft KB Archive/161899

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

Article ID: 161899

Article Last Modified on 10/22/2000

-

APPLIES TO


 * 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.

