From Excel 2003, you could use Tables. A cDataSet is somewhat like a table in that is structured data, expecting headings etc. When you use bigCommit() in cDataSet, it wipes out the existing Excel data and replaces it with the values you have changed. This has the side effect of eliminating any Excel table that may have been mapped to that data.
Here's an example of how to have cDataSet restore a table definition, or create a new one if necessary
.activeListObject() can be used to recover any tables that currently overlap a cDataSet.
.makeListObject(some name) can be used to create an Excel table with the characteristics of the cDataset
Shop Amazon Gift Cards - Perfect Gifts Anytime
You can get me on Google plus, Twitter or this forum.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Classes > Data Manipulation Classes > How to use cDataSet >