Spreadsheet.Queries

This property returns the queries collection associated with the spreadsheet.

This property is read only.

Syntax Parameters Return Value
- - Queries

SVB Example

Running a query: 

Option Base 1
Option Explicit
Sub Main
    Dim spr As Spreadsheet
    'assigns the active spreadsheet to the object spr
    Set spr = ActiveSpreadsheet
    Dim i As Integer
    'refresh every query in the spreadsheet
    For i = 1 To spr.Queries.Count
        spr.Queries(1).Refresh(True)
    Next i
End Sub