If you’re looking for just a quick way to dump it out and don’t care if it is pretty or anything, then you can use Excel’s CopyFromRecordset method which copies a recordset into a range of cells.

Note that this only works in Excel 2000 or higher (Excel 97 only supported DAO recordsets, so you’ll get an error). You can pull the recordset out of the grid and pass it off to Excel. Pretty quick way to get it done.

Dim xlApp
Dim xlWb
Dim xlWs
 
    Set xlApp = CreateObject("Excel.Application")
    Set xlWb = xlApp.Workbooks.Add
    Set xlWs = xlWb.Worksheets("Sheet1")
 
    xlApp.Visible = True
    xlApp.UserControl = True
 
    'here's the magic
    xlWs.Cells.CopyFromRecordset DataGrid1.Recordset
 
    'now auto-fit the width of the columns
    xlApp.Selection.CurrentRegion.Columns.AutoFit
 
    Set xlWs = Nothing
    Set xlWb = Nothing
    Set xlApp = Nothing

You’ll notice however, that this will dump any fields in the recordset out to Excel, including any hidden ID fields. But at least it is a quick way to get it done. I suppose you could always clone the recordset to get rid of any undesired fields.

Of course another quick way is to take the code from the existing VBScript plugin that exports groups to Excel and modify it to fit your needs. However, this way is a quick way to get that done and can easily be added to a generic include script that yo can add anytime to you need to dump a SalesLogix grid to Excel.