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