04 GetHeaders - AndrewMB2/Logic-Architect-for-Excel-VBA GitHub Wiki

GetHeaders method

Returns or sets the set of field names.

Applies to

TableData ArrData RsetData Xdata XShared

Returns the set of non-blank field names as a string, each surrounded by " (double-quote) characters and separated by commas. This can be run with debug.print to provide a list of fields which can be used when creating an ArrData or RsetData object which requires the list of field names to be provided as the first parameter.

Can also be used to set all the headers in a TableData object, in which case the information supplied should be an array of header field names, the same length as the number of columns in the TableData object. The displayed headers are not affected.