Check the SaveGrid method for FlexGrid,here is a quick look: SaveGrid Method Saves grid contents and format to a file. Syntax [form!]VSFlexGrid.SaveGrid FileName As String, SaveWhat As SaveLoadSettings, [ FixedCells As Boolean ] Remarks This method saves a grid to a binary or to a text file. The grid may be retrieved later with the LoadGrid method. Grids saved to text files may also be read by other programs, such as Microsoft Excel or Microsoft Word. The parameters for the SaveGrid method are described below: FileName As String The name of the file to create, including the path. If a file with the same name already exists, it is overwritten. SaveWhat As SaveLoadSettings This parameter specifies what should be saved. Valid options are: Constant Value Description flexFileAll 0 Save all data and formatting information. flexFileData 1 Save only the data, ignoring formatting information. flexFileFormat 2 Save only the global formatting, ignoring the data. flexFileCommaText 3 Save data to a comma-delimited text file. flexFileTabText 4 Save data to a tab-delimited text file. flexFileCustomText 5 Save data to a text file using the delimiters specified by the ClipSeparators property. flexFileExcel 6 Save all data and formatting information to an Excel97 file. This filter does not support frozen color rows or columns. Options As Variant (optional) When saving and loading text files, this parameter allows you to specify whether fixed cells are saved and restored. The default is False, which means fixed cells are not saved or restored. When saving and loading Excel files, this parameter allows you to specify the name or index of the sheet to be loaded, or the name of the sheet to be saved. If omitted, the first sheet is loaded. The options for saving fixed rows, columns, and translated combo values include: Constant Value Description flexXLSaveFixedCells 3 Saves fixed cells. flexXLSaveFixedRows 2 Saves fixed rows. flexXLSaveFixedCols 1 Saves fixed columns. flexXLSaveRaw 4 Saves raw (untranslated) data. For example, the options can be written as: fg.SaveGrid "book1.xls", flexFileExcel fg.SaveGrid "book1.xls", flexFileExcel, "sheetName" fg.SaveGrid "book1.xls", flexFileExcel, flexXLSaveFixedCells fg.SaveGrid "book1.xls", flexFileExcel, flexXLSaveFixedRows fg.SaveGrid "book1.xls", flexFileExcel, flexXLSaveFixedCols fg.SaveGrid "book1.xls"