| 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  |