Microsoft KB Archive/74842

{| = Using a Q+E DEFINE.FIELD Function With an Excel File =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q74842

SUMMARY
When using the DEFINE.FIELD macro function on an Excel file, two arguments are required regardless of the data type being defined. Omitting the second argument will result in a #REF error when executing the macro.

MORE INFORMATION
The first argument to DEFINE.FIELD defines the data type. The second argument is the maximum number of characters that will be displayed in the column. Page 93 of the &quot;Q+E for Microsoft Excel User's Guide&quot; states that unless the data type is 1 (character), the second argument is ignored. DEFINE.FIELD does ignore the second argument in cases of data types other than character; however, the second argument must be included or the function will return #REF.

Microsoft is researching this problem and will post new information here as it becomes available.