Does anyone know how to execute the sql.request so that it returns an array that can be used by other VBA methods within an excel sheet?

Thanks!