DB.PASTE.FIELDNAMES Pastes a Zero in Current Cell in Q+E

SUMMARY

If you use the DB.PASTE.FIELDNAMES function supported by the QE.XLA and leave out the first argument, "filename", 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 "paste_fields", which is a horizontal array of the field names to be pasted. If you use "paste_fields", the first argument "filename" 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("sheet1")
   A2 =DB.SET.DATABASE(FALSE,"dBASEFile","d:\excel\qe\addr.dbf")
   A3 =DB.PASTE.FIELDNAMES(,{"FIRST_NAME","LAST_NAME"})
   A4 =RETURN()

   A1 =ACTIVATE("sheet1")
   A2 =DB.SET.DATABASE(FALSE,"dBASEFile","d:\excel\xl3\qe\addr.dbf")
   A3 =DB.PASTE.FIELDNAMES("d:\excel\qe\addr.dbf")
   A4 =RETURN()

REFERENCES

"Q+E for Microsoft Excel User's Guide." Version 3.00, page 70.

README.TXT. Version 3.00, 12/9/90.