Public Sub RefreshData()

' The VBA module, 'OxlSnowflake', and class, 'OxlQueryList', in this macro are plain VBA code
' modules which are added to your workbook when you use optimal(xl)'s menu to select
' {'Tools' -> 'Configure workbook for VBA API'}
' These are not fragile type-library references and have no compile-time dependencies, i.e.,
' teammates can always open this workbook without having VBA references blow up.

' This is a strongly-typed collection class to hold one or more individual 'OxlQuery' types.
Dim queries As OxlQueryList

' Instantiate the collection class.
Set queries = New OxlQueryList

' This method will find and load all the in-cell SQL queries in your workbook
queries.LoadAllInWorkbook ThisWorkbook

' This runs the queries and updates your sheets with the results.
OxlSnowflake.RunParallel queries
End Sub