LoadGridURL Method

Loads grid contents and format from a URL (created with SaveGrid).

Syntax

[form!]VSFlexGrid.LoadGridURL URL As String, LoadWhat As SaveLoadSettings, [ Options As Variant ]

Remarks

URL As String

The URL to load, including the path.

LoadWhat As SaveLoadSettings

This parameter specifies what should be loaded. Valid options are:

 

Constant

Value

Description

flexFileAll

0

Load all data and formatting information available in the file.

flexFileData

1

Load only the data, ignoring formatting information.

flexFileFormat

2

Load only the formatting, ignoring the data.

flexFileCommaText

3

Load data from a comma-delimited text file.

flexFileTabText

4

Load data from a tab-delimited text file.

flexFileCustomText

5

Load data from a text file using the delimiters specified by the ClipSeparators property.

flexFileExcel

6

Load a sheet from an Excel97 file (you can specify which sheet to load using the Options parameter). 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.

See Also

VSFlexGrid Control