Microsoft KB Archive/71967

{| = DB.PASTE.FIELDNAMES Pastes a Zero in Current Cell in Q+E =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q71967

SUMMARY
If you use the DB.PASTE.FIELDNAMES function supported by the QE.XLA and leave out the first argument, &quot;filename&quot;, a zero will be pasted into the current cell or it will be left blank.

Once you have chosen the Paste Field Names command from the Data Menu and pasted the field name you want, the function will perform properly.

MORE INFORMATION
The README file located in the Excel directory after installing Microsoft Excel version 3.00 describes a second argument &quot;paste_fields&quot;, which is a horizontal array of the field names to be pasted. If you use &quot;paste_fields&quot;, the first argument &quot;filename&quot; may be eliminated.

The following example will NOT work correctly unless you have pasted the fieldnames LAST_NAME and FIRST_NAME by hand previously:

A1 =ACTIVATE(&quot;sheet1&quot;) A2 =DB.SET.DATABASE(FALSE,&quot;dBASEFile&quot;,&quot;d:\excel\qe\addr.dbf&quot;) A3 =DB.PASTE.FIELDNAMES(,{&quot;FIRST_NAME&quot;,&quot;LAST_NAME&quot;}) A4 =RETURN The following example WILL work correctly; however, it will paste all fieldnames: A1 =ACTIVATE(&quot;sheet1&quot;) A2 =DB.SET.DATABASE(FALSE,&quot;dBASEFile&quot;,&quot;d:\excel\xl3\qe\addr.dbf&quot;) A3 =DB.PASTE.FIELDNAMES(&quot;d:\excel\qe\addr.dbf&quot;) A4 =RETURN Microsoft is researching this problem and will post new information here as it becomes available.